Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

[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?
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable

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

View solution in original post

2 Replies
Anonymous
Not applicable

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
Specialist III
Specialist III
Author

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