Does anyone have an idea how I can loop over an excel table and write subtables out of the main table?
In the main table I have multiple columns and one column containing a category.
I want to groupby the category and create subtables for every category.
What I have done is using a GroupBy on the category column and then use the Table Row to Variable Loop Start in which I use a Rule based Row Filter to create subtables for each category.
But there is no Node to create tables where I can and the loop afterwards… or is there?
You can use the excel sheet appender to create a new file containing your individual category as a sheet. The only thing you need to do control your sheet names with your category workflow variable.
Hi @ipazin,
but nevertheless you have to define a variable with the category. So i think first use a group by node and then a tablerow to variable loops start would be the smarter option.
As @Luca_Italy said Group Loop Start node outputs flow variable groupIdentifier (concatenation of all grouping columns) together with flow variable for each grouping column holding current value.
