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