Icon

Delivery & Inventory (每天)

quantity to number format
String to Number
Unpivot
sort out values lines
Nominal Value Row Filter
Java Edit Variable (simple)
String Replacer
Date&Time Shift
sort out values lines
Nominal Value Row Filter
String Replacer
String Manipulation
String Replacer
String to Path (Variable)
CSV Writer
Java Edit Variable (simple)
Date format for D_month and snapit_week
String to Date&Time
Add ID number for each line
Column Expressions
Delivery
DB Writer
Date format for D_month and snapit_week
String to Date&Time
String to Path (Variable)
Rename to CDPID
Column Renamer
filter out total
Column Filter
Oracle Connector
Cell Splitter
Read the refresh date
Cell Extractor
料号修正
String Manipulation
String Replacer
filter out quantity is 0
Row Filter
Java Edit Variable (simple)
add snapshot date to table for each line
Variable to Table Column
Delivery Master
DB Writer
Column Renamer
String to Path (Variable)
Necessary lines for PLAN$CDPMASTER
Column Filter
Local File System Connector
Column Filter
CSV Writer
String Manipulation (Variable)
GroupBy
Column Filter
Necessary lines for PLAN$CDPTEMP
Column Filter
rename to d_month and Quantity
Column Renamer
Stock
DB Writer
filter out useless column
Column Filter
CSV Writer
Delivery
Excel Reader
Read the refresh date
Cell Extractor
Stock
Excel Reader

Nodes

Extensions

Links