Multiple Sheet in one Excel File

Hi,

I want to add multiple pages to excel. how can i make single filter as multiple output ?

For example;

output 1
{
emit *
where ‘CITY_CODE’ == 1
}

output 2
{
emit *
where ‘CITY_CODE’==2
}

output 3
{
emit *
where ‘CITY_CODE’==3
}

Thanks

Hi,

Start with group loop node, which will group your data by “City code” and send this data forward where you can write this to excel with Excel sheet appender. For the sheet name you can use variable.

1 Like

Hi,
so how can i add this to 3 sheets ?

CITY_CODE == 1 -->> SHEET_1
CITY_CODE == 2 -->> SHEET_2
CITY_CODE == 3 -->> SHEET_3

Hi,

I do not know the structure of your data but look at this workflow KNIME_project.knwf (1.1 KB) as an example and upgrade it for your needs.
The sheet name is controled by the variable.

hope this helps you

3 Likes