I’m looking for a solution to create Excel files with two columns of data inside a loop. I can create files with one column, but I’m struggling with two or more.
should look like -
field location → ABC, DEF
field country → USA, FRA
Output during the loop should be Excel files like this
ABC_USA.xlsx
DEF_FRA.xlsx
Thanks so much it helps a lot. But how can I setup the location were I want to store the date (Network drive) - currently it is C:\User\Knime-workspace