Icon

HistKPI_​ Card

Workflow to translate and transform the Summarised worksheet into a tabular table and generate a CSV file. This CSV file is then, used as an input for the next year KPI Scorecard for historical YTD KPI performance.

Node 1Node 2Node 3Node 4Node 5Node 6Node 7Node 8Node 9Node 10Node 12Node 13Node 15Node 16Node 17Node 18Node 19Node 20Node 21Node 22Excel Reader Excel Reader String Manipulation Table Creator Concatenate Column Filter ExtractColumn Header RowID RowID Joiner Insert ColumnHeader Column Filter Unpivoting Row Filter Missing Value Cell Splitter Column Resorter Table Manipulator String Manipulation CSV Writer Node 1Node 2Node 3Node 4Node 5Node 6Node 7Node 8Node 9Node 10Node 12Node 13Node 15Node 16Node 17Node 18Node 19Node 20Node 21Node 22Excel Reader Excel Reader String Manipulation Table Creator Concatenate Column Filter ExtractColumn Header RowID RowID Joiner Insert ColumnHeader Column Filter Unpivoting Row Filter Missing Value Cell Splitter Column Resorter Table Manipulator String Manipulation CSV Writer

Nodes

Extensions

Links