Challenge 32 - Change Structure of an Excel File
Level - Easy
Description - A company buys their material from different manufacturers and stores all relevant information in one excel file. In this challenge your goal is to change the structure of the excel sheet so that as little information as possible is stored repeatedly. Use as few nodes as possible to change the structure of the excel file to the output shown below (our solution has only 5 nodes, no scripting nodes, no components)
----------------------------------------------------------------------------
Several methods are designed, depending on the simplicity and the dynamic capability in handling any number of column headers in future files.
Method 2 counts the number of unique year & month combinations to set the right number of chunks for loop.
Method 3 uses collection columns to create a list for each entry of year & month combinations, which was then grouped, and expanded. The column header names have to be renamed as well.
Workflow
justknimeit-32 - Change Structure of an Excel File
Used extensions & nodes
Created with KNIME Analytics Platform version 4.6.1
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
Legal
By using or downloading the workflow, you agree to our terms and conditions.