Icon

DataPreparation

- DiscPct : ada %- PaidAmountNew : dengan mempertimbangkan DiscPct- UnitPrice : missing- SalesRepName : missing- CancelFlag : tidak konsisten (ada Yes, ada Y)- CancelFlag == Y, maka ReturnFlag ==Y dan ReturnAmount == PaidAmount CancelFlag == N, maka ReturnAmount == 0- ReturnFlag == N, maka CancelFlag == N
CSV Reader
Statistics
Cell Splitter
SalesDate (yyyy-MM-dd)
Row Filter
SalesDate (selain yyyy-MM-dd)
Row Filter
String to Date&Time
String to Date&Time
Concatenate
String Replacer
Missing Value
Column Renamer
Date Shifter
String to Number
Column Filter
Math Formula
String to Number
String to Date&Time
Date&Time Difference
Row Filter
Duplicate Row Filter
Rule Engine
Column Filter
Duplicate Row Filter
Duplicate Row Filter
Joiner
String Cleaner
Value to Missing
Math Formula
Concatenate
Row Filter
Row Filter

Nodes

Extensions

Links