You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » [resolved] Iterate rows into multiple Excel sheets
#1 2009-12-23 05:00:35
- Henry
- Guest
[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?
#2 2009-12-23 06:42:53
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 [Forum, topic 5827] [resolved] How to use Flowtoiterate.
Best regards
shong
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
#3 2009-12-23 08:22:46
- Henry
- Guest
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.
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » [resolved] Iterate rows into multiple Excel sheets