Icon

2. Reading a Multi-Sheet XLS File

1. Read input file

2. Aggregate information

3. Retain repeated "Label"/"Type" combinations

Loop over each sheet
Table Row to Variable Loop Start
Read current sheet
Excel Reader
Concatenateeach sheet
Loop End
Append column withsheet name
Constant Value Column
Column Filter
Loop through "Label"/"Type"combinations
Group Loop Start
List values, where multiple
Create Collection Column
Table Transposer
Loop End
Table Transposer
Column Appender
Count occurrences
GroupBy
Row Filter
Row Filter
Row Filter
Combinations that appearedin 4 different input sheets
Column Filter
Get sheet names
Read Excel Sheet Names

Nodes

Extensions

Links