Icon

20230208 Pikairos Complicated Counting Problem

This workflow illustrates how to read the name of different Excel sheets to use them to read the sheets with a loop and gather the information to generate a unique final table.

ReadCurrent SheetRead ExcelSheet NamesExcludeTargetSheetLoop overExcel SheetsClose Loop toConcatenate Resultsas RowsFilter Rowwith UselessDataAggregatePartsAcrossColumnsUngroup Partsto have them inSeparate RowsSet KST valuesin New ColumnAdd Columnwith CurrentSheet NameSet Columnsin Desired FinalOrderFilter OutRows withMissing ValuesExcel Reader Read ExcelSheet Names Row Filter Table Row ToVariable Loop Start Loop End Row Filter Transpose Column Aggregator Ungroup RowID ConstantValue Column Column Resorter Missing Value ReadCurrent SheetRead ExcelSheet NamesExcludeTargetSheetLoop overExcel SheetsClose Loop toConcatenate Resultsas RowsFilter Rowwith UselessDataAggregatePartsAcrossColumnsUngroup Partsto have them inSeparate RowsSet KST valuesin New ColumnAdd Columnwith CurrentSheet NameSet Columnsin Desired FinalOrderFilter OutRows withMissing ValuesExcel Reader Read ExcelSheet Names Row Filter Table Row ToVariable Loop Start Loop End Row Filter Transpose Column Aggregator Ungroup RowID ConstantValue Column Column Resorter Missing Value

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: Molina
Created at: 2023-02-08
On NodePit since: 2023-02-09
Last update: 2024-04-27
Created with KNIME version: v4.5.2
Tags: Read Excel Sheet NamesTransposeTable Row to Variable Loop StartColumn AggregatorUngroupConstant Value ColumnLoop End

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

Try NodePit Runner!