[resolved] Iterate rows into multiple Excel sheets

One Star

[resolved] Iterate rows into multiple Excel sheets

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?

Accepted Solutions
Community Manager

Re: [resolved] Iterate rows into multiple Excel sheets

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
----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

Re: [resolved] Iterate rows into multiple Excel sheets

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] Iterate rows into multiple Excel sheets

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