Icon

justknimeit-32

justknimeit-32
Solution: Transpose Table using LoopsLevel: EasyDescription: A company buys their material from different manufacturers and stores all relevantinformation in one excel file. In this challenge your goal is to change the structure of the excelsheet so that as little information as possible is stored repeatedly. Use as few nodes aspossible to change the structure of the excel file to the output shown below (our solution hasonly 5 nodes, no scripting nodes, no components). Author: Victor PalaciosData: Excel table in the KNIME Hub ReadStructureLoop each6 rowsCollateHorizontallyResetRowIDsRemoveYear & MonthIterations Excel Reader Chunk Loop Start Loop End (ColumnAppend) RowID Column Filter Solution: Transpose Table using LoopsLevel: EasyDescription: A company buys their material from different manufacturers and stores all relevantinformation in one excel file. In this challenge your goal is to change the structure of the excelsheet so that as little information as possible is stored repeatedly. Use as few nodes aspossible to change the structure of the excel file to the output shown below (our solution hasonly 5 nodes, no scripting nodes, no components). Author: Victor PalaciosData: Excel table in the KNIME Hub ReadStructureLoop each6 rowsCollateHorizontallyResetRowIDsRemoveYear & MonthIterations Excel 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: UserID
Created at: 2022-08-31
On NodePit since: 2022-09-01
Last update: 2024-11-21
Created with KNIME version: v4.6.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!