Create new tabs in an excel sheet based off a column name

Hi @aksyracuse , you don’t load data into a Table Creator other than manually. The Table Creator is just there as an example. Replace the table creator node with an Excel Reader node, to read the data from your existing excel file.
i.e.
image

edit:

Incldentally one option for having the output Excel file “overwritten” on the first iteration, but then subsequently appended to is as attached:

Here a flow variable is created at the beginning of each iteration which sets the a variable containing the excel file overwrite option to either “overwrite” or “append”.

image

This is then configured on the flow variables tab of the Excel Writer:

Group Loop and Write Excel Sheet 2.knwf (18.8 KB)

2 Likes