Icon

Challenge 32 - Change Structure of an Excel File

Challenge 32 - Change Structure of an Excel File
READ DATA & CLEANING Description: 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 information as possible isstored repeatedly. Use as few nodes as possible to change the structure of the excel file to the output shown below (our solutionhas only 5 nodes, no scripting nodes, no components). Challenge 32: Change Structure of an Excel File Read Input(only current sructure)6 rows per iterationCollect columnsby Row IDResetRow IDExcludeYear and MonthExcel Reader Chunk Loop Start Loop End (ColumnAppend) RowID Column Filter READ DATA & CLEANING Description: 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 information as possible isstored repeatedly. Use as few nodes as possible to change the structure of the excel file to the output shown below (our solutionhas only 5 nodes, no scripting nodes, no components). Challenge 32: Change Structure of an Excel File Read Input(only current sructure)6 rows per iterationCollect columnsby Row IDResetRow IDExcludeYear and MonthExcel Reader Chunk Loop Start Loop End (ColumnAppend) RowID Column Filter

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: USER
Created at: 2022-08-31
On NodePit since: 2022-09-01
Last update: 2024-11-21
Created with KNIME version: v4.5.0
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!