[resolved] Iterate rows into multiple Excel sheets

[_AnonymousUser]

Hi,
I would like to create a job like this:
1. using tMSSqlInput to read list of employees in 1 table, resulting in:
1, Henry
2, Other employee
2. From the ID retrieved, I would like to get the list of projects:
1, Project A
2, Project B
3. Dump the info to an Excel file into multiple sheet (sheet name based on the employee ID).
Can I achieve this using Talend?

[Anonymous · Accepted solution]

Hello

Can I achieve this using Talend?

Of course, you can use tFlowToIterate component, a simple looks like my screenshots shows.
About tFlowToIterate usage, see 5827.
Best regards

shong

[_AnonymousUser]

Hi Shong,
I've tried your solution and it works!
Thanks for your prompt reply.
Happy holiday.