Icon

CDP & ACCO2 (每周一,周二,周三)

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

Nodes

Extensions

Links