Icon

2020_​10_​22_​From_​Excel_​to_​KNIME_​Table_​Unpivoting

From Excel to KNIME table Unpivoting
From Excel to KNIME table UnpivotingThis workflow demonstrates how to convert specific Excel table format to desired one using KNIME Unpivoting node.Forum link: https://forum.knime.com/t/columns-for-each-row/28138 Data cleaning Data preparation Input Excel dataSplitt first two rowsTransposeCombine for new HeadersInsert new headersUnpivot dataSplit former headersTable Creator Row Splitter Transpose Column Combiner Insert ColumnHeader Unpivoting Cell Splitter Column Filter Column Rename Column Resorter From Excel to KNIME table UnpivotingThis workflow demonstrates how to convert specific Excel table format to desired one using KNIME Unpivoting node.Forum link: https://forum.knime.com/t/columns-for-each-row/28138 Data cleaning Data preparation Input Excel dataSplitt first two rowsTransposeCombine for new HeadersInsert new headersUnpivot dataSplit former headersTable Creator Row Splitter Transpose Column Combiner Insert ColumnHeader Unpivoting Cell Splitter Column Filter Column Rename Column Resorter

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: Johnny
Created at: 2019-01-03
On NodePit since: 2020-10-22
Last update: 2024-04-28
Created with KNIME version: v4.2.2
Tags: Data ManipulationUnpivotingExcel ProcessingHeader Manipulation

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

Try NodePit Runner!