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]

Hi @nthampi ,

after tmap_1 if i place tlogrow then it displays correct data but if i place tlogrow after tfixedflowinput then it displays null

[Anonymous]

Ok. This means that your tFlowtoiterate mapping is not correct.

Could you please select the checkbox (Use the default key value in global variables)? This should make sure that no manual mapping errors are present. instead of tFixedFlowinput, could you please try trowgenerator as below?

Ideally it should propagate the data to downstream systems.

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 🙂

[kuwaryogi27 · Accepted solution]

Hi @MeghanaKottala ,

The solution you provided worked for me.
Thank you all for your valuable time.
Attaching the solution provided by @MeghanaKottala , so that it can be helpful to all

Regards,
Yogesh.

Done.PNG

[kuwaryogi27]

Hi @MeghanaKottala , @nthampi , @uganesh  ,

Thank you for your valuable time, i really appreciate it from the bottom of my heart.
Looking forward to stay connected and need you guidance.
Cheers!!

Regards,
Yogesh.