Icon

justknimeit-32

justknimeit-32
Challenge 32: Change Structure of an Excel FileDescription: A company buys their material from different manufacturers and stores all relevant information inone excel file. In this challenge your goal is to change the structure of the excel sheet so that as little informationas possible is stored repeatedly. Use as few nodes as possible to change the structure of the excel file to theoutput shown below (our solution has only 5 nodes, no scripting nodes, no components). Read current.xlsxsort by Year, MonthCompanyPivot for year, month and rankReset RowIdCreate rank for pivotingdesired.xlsx Excel Reader Sorter Pivoting RowID Rank Excel Writer Challenge 32: Change Structure of an Excel FileDescription: A company buys their material from different manufacturers and stores all relevant information inone excel file. In this challenge your goal is to change the structure of the excel sheet so that as little informationas possible is stored repeatedly. Use as few nodes as possible to change the structure of the excel file to theoutput shown below (our solution has only 5 nodes, no scripting nodes, no components). Read current.xlsxsort by Year, MonthCompanyPivot for year, month and rankReset RowIdCreate rank for pivotingdesired.xlsx Excel Reader Sorter Pivoting RowID Rank Excel Writer

Nodes

Extensions

Links