Icon

34755

Get structure of datasets within the Excelsheet Read each dataset separately and combine the results Read completesheetAdd column with Row ID'sGet row with "strings"Remove "Row"from the textChange rowid'sinto numbersGet first rowOn next datasetsget row of headercorrectCombineTo get beginrownext to endrowof datasetRead each datasetby changing thesheet rangeSkip what isnot necessaryBegin column BEnd column ZZAvoid readingbefore first rowLoop through each datasetCombine the resultsAdd 1 toeach rowMerge rowsfor uniqueAccount names Excel Reader RowID Row Filter String Manipulation String To Number GroupBy Math Formula Concatenate Lag Column Excel Reader Column Filter Rule Engine Rule Engine Row Filter Table Row ToVariable Loop Start Loop End Math Formula GroupBy Get structure of datasets within the Excelsheet Read each dataset separately and combine the results Read completesheetAdd column with Row ID'sGet row with "strings"Remove "Row"from the textChange rowid'sinto numbersGet first rowOn next datasetsget row of headercorrectCombineTo get beginrownext to endrowof datasetRead each datasetby changing thesheet rangeSkip what isnot necessaryBegin column BEnd column ZZAvoid readingbefore first rowLoop through each datasetCombine the resultsAdd 1 toeach rowMerge rowsfor uniqueAccount namesExcel Reader RowID Row Filter String Manipulation String To Number GroupBy Math Formula Concatenate Lag Column Excel Reader Column Filter Rule Engine Rule Engine Row Filter Table Row ToVariable Loop Start Loop End Math Formula GroupBy

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: in732mel
Created at: 2021-07-20
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.3.4

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

Try NodePit Runner!