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]

Attached are the job changes suggested by you guys.
PFA

error1.PNG
scenario1.PNG

[Anonymous]

what have you given in tFixedFlowInput ?

[kuwaryogi27]

Please find below attached screenshots of tflowtoiterate and tfixedflowinput

tFixedFlowInput_2.PNG
tFlowToIterate_1.PNG

[Anonymous]

Hi,

     Please put a tLogrow before and after tjavarow and see whether the data is present in both tLogrow.

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]

In first tlogrow its displaying the data but in second tlogrow it is giving null values

[Anonymous]

Perfect.

So the mapping from input to output columns is not happening correctly in tjavarow.

Could you please try for one column using automapping and check the difference.

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]

Hi @nthampi ,

Did the auto mapping but still getting null, i am attaching the output excel please have a look

[Anonymous]

Hi,

    I did a similar one and its working fine.

    Could you please also add a System.out.print(input_row.id) to make sure that input data is coming correctly to tjavarow.

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]

Hi @nthampi ,

I am doing the same but after tflowtoiterate in my job tfixedflowinput is there after that i have tjavarow component in which i have synced the columns and simply clicked on generate code.
after tmap its giving me proper output but after tfixedflow its giving me null i have attached the input files as well you can try the same at your end.

tjavarow.PNG

[Anonymous]

@ykasture 

Sorry. Your previous post is slightly confusing for me.

You were telling that you added a tLogrow before tjavarow (which comes after tfixedflowinput) and you could see the data is present in in the tLogrow before tjavarow.

But you are not getting data after tjavarow and when you added a tLogrow, you got the value as null. In this case, the issue could happen only within tjavarow.

So you need to print the input data by System.out.print() and see whether the data from input_row is coming correctly. Ideally it should since you are able to see them in tLogrow before it.

Then you need to assign the mapping for one column and see the output in tLogrow after tjavarow. Ideally it should work. Still you are facing issue, let us know.

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 🙂