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

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: eyilmaz35
Created at: 2022-09-01
On NodePit since: 2022-09-02
Last update: 2024-04-27
Created with KNIME version: v4.6.1
Tags: justknimeit-32

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!