Icon

KNIME_​unfitted_​excels_​v3

Modified from @takbb in "Find Header Row For Excel":https://forum.knime.com/t/using-an-excel-map-file-to-replace-concepts-in-excel-source-file/33637/6 Excel input looks like thisSearch String "Year"Generate 1-based rownumberLook for required String in Col ASplit first row with headernamesCounter to variableRemove missingcolumnsReplace column headersin dataRead column namesfrom unpivoted 'ColumnNames'and sed to LoopLoop feederSearch in any columnCounter to variableNode 16Node 21Node 23Earliest rowcontaining the requiredstring in any ColumnRemove 'wording above'Generate two columns:aiming to correlate current column names with new column names in next noderemoveCounterSplit first row with headernamesRemove missingcolumns Table Creator String Input Counter Generation Row Filter Row Splitter Table Rowto Variable Missing ValueColumn Filter Insert ColumnHeader Unpivoting Column Filter Group Loop Start Table Rowto Variable Empty Table Switch Loop End End IF GroupBy Rule-basedRow Filter Unpivoting Column Filter Row Splitter Missing ValueColumn Filter Modified from @takbb in "Find Header Row For Excel":https://forum.knime.com/t/using-an-excel-map-file-to-replace-concepts-in-excel-source-file/33637/6 Excel input looks like thisSearch String "Year"Generate 1-based rownumberLook for required String in Col ASplit first row with headernamesCounter to variableRemove missingcolumnsReplace column headersin dataRead column namesfrom unpivoted 'ColumnNames'and sed to LoopLoop feederSearch in any columnCounter to variableNode 16Node 21Node 23Earliest rowcontaining the requiredstring in any ColumnRemove 'wording above'Generate two columns:aiming to correlate current column names with new column names in next noderemoveCounterSplit first row with headernamesRemove missingcolumns Table Creator String Input Counter Generation Row Filter Row Splitter Table Rowto Variable Missing ValueColumn Filter Insert ColumnHeader Unpivoting Column Filter Group Loop Start Table Rowto Variable Empty Table Switch Loop End End IF GroupBy Rule-basedRow Filter Unpivoting Column Filter Row Splitter Missing ValueColumn 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: RE90273
Created at: 2021-06-18
On NodePit since: 2022-02-06
Last update: 2024-05-01
Created with KNIME version: v4.3.1

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

Try NodePit Runner!