topic How to split an output to excel sheets? in Talend Studio

How to split an output to excel sheets?

Ghosh612 — Fri, 26 Mar 2021 10:46:31 GMT

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.

Re: How to split an output to excel sheets?

Anonymous — Mon, 29 Mar 2021 04:54:53 GMT

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

Re: How to split an output to excel sheets?

Prakhar1 — Mon, 29 Mar 2021 06:34:21 GMT

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")

Re: How to split an output to excel sheets?

Ghosh612 — Fri, 09 Apr 2021 09:56:38 GMT

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 🙂