How to split an output to excel sheets?

[Ghosh612]

Hello All,

I have this requirement where I need produce an output of the data in multiple excel sheets.

The data contains Country_Name, if there are 3 countries in the field, there should be 3 sheets by country name and the data for the respective country will be displayed only in the country sheets.

I am using tUniqRow to find the unique country names, and was thinking of creating sheets according to the field values. But I am clueless after the tUniqRow component.

Can anyone help?

Thank You,

Shounak Ghosh.

[Anonymous]

Hello,

Could you please explain this better? Giving more details regarding the expected output dispatching files will be preferred.

Are you trying to write your output in the same excel file but in different sheets?

Best regards

Sabrina

[Prakhar1 · Accepted solution]

Follow below steps :

1) Read the source file

2) use tUnique to find uniques

3)use tflowtoiterate then iterate over source file again

4) use tfilterRow and then filter those rows having same country name by using the globalvariable of tUniqRow

5) then use tFileOutputExcel and in the file name use the same global variable again

sourceFile --> tUniq----uniques--> tFlowToIterate --iterate--> sourceFile -->tFilterRow ( column having country name == (String)globalMap.get("row2.column_having_country_name")) -->tFileOutputExcel (filename== 'c:/talend/' + (String)globalMap.get("row2.column_having_country_name")

[Ghosh612]

Replying late on this, but thank you so much. I did mine with reference to your's, just that instead of unirow I used a tMap component.Works like a charm.

Thank you 🙂