Icon

KPN project

raw_crm_ticket

raw_dma_master

raw_cis_customer_master

Fotmat วันที่

raw_scada_system_input (Fact)

Fotmat วันที่

raw_wqm_test_point_master.csv (dimension)

raw_wqm_quality_test.csv (fact):

raw_cis_billing

Fotmat วันที่ billing_month

Fotmat วันที่ payment_date

Fotmat วันที่ และเวลา

Fotmat วันที่ และเวลา report_datetime

Fotmat วันที่ และเวลา dispatch_datetime

Fotmat วันที่ และเวลา repair_complete_datetime

Add SLASH branch
Concatenate
String to Date&Time
Expression
Date order
Expression
Strip time from date_step1
Expression
Filter ลบ.ม. rows
Row Filter
Thai month to slash
Expression
DMY split
Row Splitter
Parse MDY
String to Date&Time
String to Date&Time
Extract time part
Expression
Join median lookup
Joiner
Column Renamer
Compute volume m3
Expression
Add SLASH branch
Concatenate
Median by dma_code
GroupBy
Split MDY vs others
Row Splitter
Rename to median_m3
Column Renamer
String to Date&Time
Concatenate parsed dates
Concatenate
Constant Value Column Appender
CSV Reader
Final SLASH result
Concatenate
Final columns
Column Filter
DMY split
Row Splitter
Expression
Column Renamer
Duplicate Row Filter
Date group
Expression
Required check
Rule Engine
Column Merger
Row Splitter
String to Date&Time
Required check
Rule Engine
Split Buddhist era
Row Splitter
Parse DMY
String to Date&Time
Column Filter
Combine all parsed branches
Concatenate
CSV Reader
Date order
Expression
ISO split
Row Splitter
Column Filter
Shift -543 years
Date Shifter
Valid split
Row Splitter
Add SLASH branch
Concatenate
Dedup unique
Duplicate Row Filter
Parse DMY
String to Date&Time
CSV Reader
Column Merger
Required check
Rule Engine
Parse MDY
String to Date&Time
Column Merger
Date order
Expression
Parse DMY
String to Date&Time
String to Date&Time
Constant Value Column Appender
Split MDY vs others
Row Splitter
Column Renamer
Column Renamer
Parse MDY
String to Date&Time
Concatenate parsed dates
Concatenate
Concatenate parsed dates
Concatenate
Split Buddhist era
Row Splitter
Combine all parsed branches
Concatenate
Split MDY vs others
Row Splitter
Shift -543 years
Date Shifter
Shift -543 years
Date Shifter
Column Filter
DMY split
Row Splitter
Column Renamer
Thai month to slash
Expression
Split Buddhist era
Row Splitter
ISO split
Row Splitter
Date group
Expression
Final SLASH result
Concatenate
Combine all parsed branches
Concatenate
Date group
Expression
Thai month to slash
Expression
Final SLASH result
Concatenate
ISO split
Row Splitter
Split MDY vs others
Row Splitter
Final SLASH result
Concatenate
Valid split
Row Splitter
Dedup all columns
Duplicate Row Filter
Parse DMY
String to Date&Time
Combine all parsed branches
Concatenate
Date group
Expression
Column Merger
ISO split
Row Splitter
Column Renamer
Parse MDY
String to Date&Time
Concatenate parsed dates
Concatenate
DMY split
Row Splitter
Add SLASH branch
Concatenate
String to Date&Time
Split Buddhist era
Row Splitter
Date order
Expression
Column Renamer
String to Date&Time
Shift -543 years
Date Shifter
Extract time part
Expression
Column Filter
Strip time from date_step1
Expression
String to Date&Time
Date group
Expression
Column Renamer
Thai month to slash
Expression
String to Date&Time
Column Renamer
Column Merger
Column Filter
Final SLASH result
Concatenate
Date order
Expression
Extract time part
Expression
String to Date&Time
Strip time from date_step1
Expression
Column Renamer
Split MDY vs others
Row Splitter
raw_dma_master
CSV Reader
Split Buddhist era
Row Splitter
Expression
GroupBy
Concatenate parsed dates
Concatenate
Column Renamer
Joiner
Column Merger
Rule Engine
Column Filter
Parse DMY
String to Date&Time
DMY split
Row Splitter
Extract time part
Expression
ISO split
Row Splitter
Thai month to slash
Expression
Combine all parsed branches
Concatenate
CSV Reader
Shift -543 years
Date Shifter
Strip time from date_step1
Expression
Parse MDY
String to Date&Time
Row Splitter
Rule Engine
Add SLASH branch
Concatenate
Duplicate Row Filter
CSV Reader
Split MDY vs others
Row Splitter
Row Splitter
Date group
Expression
Duplicate Row Filter
Final SLASH result
Concatenate
Parse DMY
String to Date&Time
Column Merger
ISO split
Row Splitter
Combine all parsed branches
Concatenate
Parse MDY
String to Date&Time
Column Renamer
String to Date&Time
Add SLASH branch
Concatenate
Date group
Expression
ISO split
Row Splitter
DMY split
Row Splitter
Concatenate parsed dates
Concatenate
Parse DMY
String to Date&Time
Column Renamer
Parse MDY
String to Date&Time
DMY split
Row Splitter
Date order
Expression
Split Buddhist era
Row Splitter
Split MDY vs others
Row Splitter
String to Date&Time
Shift -543 years
Date Shifter
Shift -543 years
Date Shifter
Final SLASH result
Concatenate
Date order
Expression
Concatenate parsed dates
Concatenate
Thai month to slash
Expression
Split Buddhist era
Row Splitter
Column Filter
DMY split
Row Splitter
Add SLASH branch
Concatenate
String to Date&Time
Concatenate parsed dates
Concatenate
Combine all parsed branches
Concatenate
Final SLASH result
Concatenate
Column Merger
Column Renamer
String to Date&Time
String to Date&Time
Column Renamer
Column Merger
Date group
Expression
Column Filter
Combine all parsed branches
Concatenate
Date order
Expression
Split Buddhist era
Row Splitter
Column Renamer
Parse DMY
String to Date&Time
Column Renamer
ISO split
Row Splitter
Date_cleaned
Column Filter
Add SLASH branch
Concatenate
Shift -543 years
Date Shifter
Parse MDY
String to Date&Time
Thai month to slash
Expression
String to Date&Time
Split MDY vs others
Row Splitter
Filter ลบ.ม. rows
Row Filter
Column Renamer
Median by customer
GroupBy
Expression
Joiner
Row Splitter
Constant Value Column Appender
Final columns
Column Filter
Extract regex match
Expression
Required check
Rule Engine
Set reason
Rule Engine
CSV Reader
Add source_file
Constant Value Column Appender
Dedup ticket_id
Duplicate Row Filter
Thai month to slash
Expression
Row Splitter
Deduplicate customer_id
Duplicate Row Filter
Add source_file
Constant Value Column Appender

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: minkhant
Created at: 2026-09-16
On NodePit since: 2026-09-16
Last update: 2026-09-22
Created with KNIME version: v5.12.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!