Hi,
I am new in Talend. I am stucked at a point.
I want multiple sheet in a single excel output . The number of sheet depend on contain.
let takes an example
main excel
id | category | description
1 | wiki | asdfkj
2 | youtube | asdfhjg
3 | picasa | asdfjkah
4 | wiki | asdfkj
5 | youtube | asdfhjg
6 | picasa | asdfjkah
now based on category i need the sheet should be created . and one more thing category can be more so cannot fixed on 3 or 4 filters
Hi
Ok, I understand what you need now, you need to iterate each row and set a dynamic sheet name. For example:
tFileInputExcel---row1--tFlowToIterate--iterate-->tFileOutputExcel
on tFileOutputExcel, set the 'Sheet name' field as: (String)gloalMap.get("row1.category")
Best regards
Shong
Thanx for your reply , but I cannot connect
tFlowToIterate--iterate-->tFileOutputExcel
Apart from it I have tried to set sheet name using context variable .
In that case the sheet name takes only the initial value of the variable but not the updated values .
Hi
Sorry, it was a wrong job design, the correct job looks like:
tFileInputExcel---row1--tFlowToIterate--iterate-->tFixedFlowInput--main--tFileOutputExcel
on tFixedFlowInput, generate each row of row1, define three columns on schema,
column:value
id:row1.id
category:row1.category
description:row1.description
Best regards
Shong
