Multiple Sheet in one Excel File

KNIME Analytics Platform
,
#1

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

#2

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
#3

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

#4

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