Icon

KNIME_​project8

Node 1Node 2Node 3Node 5get value of previous monthsNode 7Node 8calc MTD valueNode 10Node 11get value for first monthNode 13Node 14Node 15Node 16Node 20Node 21loop over all columns which you want to transform from YTD->MTDNode 23Node 24get value of previous monthsrename current column to currColcalc MTD valueget value for first monthrename outputremoveold columnsget oldcolumnsget MTD nameExcel Reader (XLS) Column Resorter Row Filter Group Loop Start Lag Column Lag Column Lag Column Math Formula Math Formula Math Formula Rule Engine Rule Engine Rule Engine Column Rename Loop End Loop End Group Loop Start Column ListLoop Start Loop End (ColumnAppend) Column Filter Lag Column Column Rename Math Formula Rule Engine Column Rename Column Filter Column Appender String Manipulation(Variable) Node 1Node 2Node 3Node 5get value of previous monthsNode 7Node 8calc MTD valueNode 10Node 11get value for first monthNode 13Node 14Node 15Node 16Node 20Node 21loop over all columns which you want to transform from YTD->MTDNode 23Node 24get value of previous monthsrename current column to currColcalc MTD valueget value for first monthrename outputremoveold columnsget oldcolumnsget MTD nameExcel Reader (XLS) Column Resorter Row Filter Group Loop Start Lag Column Lag Column Lag Column Math Formula Math Formula Math Formula Rule Engine Rule Engine Rule Engine Column Rename Loop End Loop End Group Loop Start Column ListLoop Start Loop End (ColumnAppend) Column Filter Lag Column Column Rename Math Formula Rule Engine Column Rename Column Filter Column Appender String Manipulation(Variable)

Nodes

Extensions

Links