Talend community forum / Purpose of tFlowToIterate and tIterateToFlow

tpk · 2012-06-26 17:08:31

Hi Team,

I was trying to understand the exact purpose of tFlowToIterate and tIterateToFlow components. I tried to understand the components by reading the documentation available for the components, but it could not help me. I didn't exactly understand the actual use.

Can any one explain me with a good scenario that can be easily understandable and grasped.

Thanks in advance for the solutions you are going to post.

Thanks and Regards,
Pavan

pedro · 2012-06-27 05:31:58

Hi Pavan

Two scenarios would explain these two components.

Scenario 1---tFlowToIterate:
Let's say we have a mysql table called tableA which contains queries like "select * from tableB". I need to extract thses queries from tableA and use them for extracting data from tableB.
tMysqlInput(tableA)--main(row1)-->tFlowToIterate--Iterate-->tMysqlInput_2--main-->tLogRow
In tMysqlInput_2, I type this expression 'row1.query' in the query text field on tMysqlInput_2 for further extraction.

Scenario 2---tIterateToFlow:
tFileList--Iterate-->tIterateToFlow-->tLogRow
How can I get all file names from the specified directory and print them on console?
Use tIterateToFlow as the following image.

Regards,
Pedro

Uploaded Images

tpk · 2012-06-27 12:24:52

Hi Pedro,

Thank you for the scenarios!

Thanks and Regards,
Pavan

pedro wrote:
Hi Pavan

Two scenarios would explain these two components.

Scenario 1---tFlowToIterate:
Let's say we have a mysql table called tableA which contains queries like "select * from tableB". I need to extract thses queries from tableA and use them for extracting data from tableB.
tMysqlInput(tableA)--main(row1)-->tFlowToIterate--Iterate-->tMysqlInput_2--main-->tLogRow
In tMysqlInput_2, I type this expression 'row1.query' in the query text field on tMysqlInput_2 for further extraction.

Scenario 2---tIterateToFlow:
tFileList--Iterate-->tIterateToFlow-->tLogRow
How can I get all file names from the specified directory and print them on console?
Use tIterateToFlow as the following image.

Regards,
Pedro

Announcement

Unanswered posts

#1 2012-06-26 17:08:31

Purpose of tFlowToIterate and tIterateToFlow

#2 2012-06-27 05:31:58

Re: Purpose of tFlowToIterate and tIterateToFlow

#3 2012-06-27 12:24:52

Re: Purpose of tFlowToIterate and tIterateToFlow

pedro wrote:

Board footer