
Anonymous
Not applicable
2015-02-17
05:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
[resolved] Do a Loop on TMap
Hi all,
I need to do a "Loop" on a TMap for write data in CSV output.
This TMap did 3 out(CSV), and on of 1 output wanted to do a Loop (2 times) for write 2 lines. Just on 1 CSV...If do you see ^^
Thanks
I need to do a "Loop" on a TMap for write data in CSV output.
This TMap did 3 out(CSV), and on of 1 output wanted to do a Loop (2 times) for write 2 lines. Just on 1 CSV...If do you see ^^
Thanks
653 Views
1 Solution
Accepted Solutions

Specialist III
2015-02-18
05:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
If you are trying to print the each inputrow into a csv file (Table_obs_fluoro.csv) for multiple times (in your case 2) using tLoop, you can go ahead like this.
tMap -->tFlowtoIterate -->tLoop -->tIterateToFlow--csv file
configure all your column names in tIterateToFlow component in a key ,value pair passion but in the value section map your column value with tFlowToIterate column name like ((String)globalMap.get("out.columnname"))
Hope that helps you.
If you are trying to print the each inputrow into a csv file (Table_obs_fluoro.csv) for multiple times (in your case 2) using tLoop, you can go ahead like this.
tMap -->tFlowtoIterate -->tLoop -->tIterateToFlow--csv file
configure all your column names in tIterateToFlow component in a key ,value pair passion but in the value section map your column value with tFlowToIterate column name like ((String)globalMap.get("out.columnname"))
Hope that helps you.
653 Views
7 Replies

Anonymous
Not applicable
2015-02-17
03:28 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have not a clear idea what you are trying to do but you can create in the tMap so called joined outputs which are send their records to the real output.
653 Views

Anonymous
Not applicable
2015-02-18
01:54 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I understand that there are 3 outputs from tMap. From one of the outputs (out3), you want to write the output of out3 twice in the target file. is that correct?
Thanks,
Karthikeyan J.
www.mytalend.in
Thanks,
Karthikeyan J.
www.mytalend.in
653 Views

Anonymous
Not applicable
2015-02-18
02:58 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No, a joined output does not appears at real output outside the tMap. A joined output sends it records to the real output. This way you can use a wide schema and unfold it to build from one input record multiple output records.
653 Views

Anonymous
Not applicable
2015-02-18
03:44 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
653 Views

Specialist III
2015-02-18
05:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
If you are trying to print the each inputrow into a csv file (Table_obs_fluoro.csv) for multiple times (in your case 2) using tLoop, you can go ahead like this.
tMap -->tFlowtoIterate -->tLoop -->tIterateToFlow--csv file
configure all your column names in tIterateToFlow component in a key ,value pair passion but in the value section map your column value with tFlowToIterate column name like ((String)globalMap.get("out.columnname"))
Hope that helps you.
If you are trying to print the each inputrow into a csv file (Table_obs_fluoro.csv) for multiple times (in your case 2) using tLoop, you can go ahead like this.
tMap -->tFlowtoIterate -->tLoop -->tIterateToFlow--csv file
configure all your column names in tIterateToFlow component in a key ,value pair passion but in the value section map your column value with tFlowToIterate column name like ((String)globalMap.get("out.columnname"))
Hope that helps you.
654 Views

Anonymous
Not applicable
2015-02-18
05:18 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hey ! So nice
Its that, and Job OK ! Good explain.
Good day,
Best regards all.
Its that, and Job OK ! Good explain.
Good day,
Best regards all.
653 Views

Anonymous
Not applicable
2016-04-08
06:19 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have 2 JDBC Input tables - tJDBCInput (for example student and course). The student table has an primary key which will used as foreign key in course table. So If any student studying more than one course, we'll have multiple entry in course table for that student id.
I want to get all those multiple entries which are matching with student id and store it in another table.
I am new to Talend, Can some one please help me. It is really appreciated. Thanks
Thanks and Regards,
Ram
I want to get all those multiple entries which are matching with student id and store it in another table.
I am new to Talend, Can some one please help me. It is really appreciated. Thanks
Thanks and Regards,
Ram
653 Views
