topic Re: [resolved] Iterate rows into multiple Excel sheets in Talend Studio

[resolved] Iterate rows into multiple Excel sheets

_AnonymousUser — Sat, 16 Nov 2024 13:38:01 GMT

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?

Re: [resolved] Iterate rows into multiple Excel sheets

Anonymous — Wed, 23 Dec 2009 05:42:53 GMT

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

Re: [resolved] Iterate rows into multiple Excel sheets

_AnonymousUser — Wed, 23 Dec 2009 07:22:46 GMT

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