How to create multiple excel sheets in talend in same subjob

[kuwaryogi27]

Hi All,

How to create multiple excel sheets in talend in same subjob.
Attaching the Excel Final_GS1_Clothing_PC.xlsx, in this file i want to generate seperate excel sheet based on identical Id column.
eg : row 2,3,4 and 5 have same Id's i want to generate a sheet name starting with the Id column value and all the same id rows should get added in that sheet.

Please let me know if you have any questions.

Regards,
Yogesh.

[kuwaryogi27]

I have also referred link https://community.talend.com/t5/Design-and-Development/Create-Multiple-Tabs-with-single-excel-file-b... but it is not working and giving me the following error.

error.PNG

[akumar2301]

Link Provided should work.

NULL is coming because , tFileInputExcel is trying to read Records after End of line

Try 1) in Advance Setting of tFileInputExcel 

select "Stop reading on encountering empty rows"

Try2) in tFileOutExcel , define some dummy name if sheetname is NULL

e.g.

((String)globalMap.get("row1.sheetname")) == null or  ((String)globalMap.get("row1.sheetname")).length()== 0 ? "dummy"(String)globalMap.get("row1.sheetname"))

[kuwaryogi27]

Hi Abhishek,

I am able to generate multiple sheets in tOutputExcel but the data is coming as null.
I have attached the talend job screenshot please check
Regards,
Yogesh.

Job.PNG

[akumar2301]

Can you just try to put tLogRow and check if data is comiing correct before tFileexcelOutput.

if tLogRow print , your result , give us screenshot of tFileexcelOutput.

[Anonymous]

Hi Yogesh,

    Most probably you might not have assigned the output of tFlowtoTerate columns after iteration correctly.

    Please add tLogrow before and after to do the testing and you will get the clue.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

What do you have in tJavaRow component?

Say if you have input schema as a,b,c and output schema as a,b,c for tJavaRow component.

You must mention in tJavaRow component as

output_row.a=input_row.a;

output_row.b=input_row.b;

output_row.c=input_row.c;

If you do not do this, you will get empty data in output excel file.

I hope, this solves your problem.

Thanks,

Meghana.

[kuwaryogi27]

Hi @nthampi ,

Before tFlowToIterate it is able to display data. I am unable to connect tlogrow after tflowtoiterate

[kuwaryogi27]

Hi @uganesh ,

I have connected tLogRow before the tFileOutputExcel but i am getting null

[kuwaryogi27]

Hi @MeghanaKottala ,

I am doing the same,  output_row.a=input_row.a;
till tMap_1 i am getting the correct data but after tFlowToIterate flow i am getting null values