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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Loop in folders for files and records

Hi  

 

I need a help to find loop handling 

 

Scenario :

I have 5 files with 100 records each.

I want to take 1st file and load 10 records as loop and load into db. Once first file is over then 2nd file and again load 10 records as loop and load into db. It should iterate for all 5 files.

 

Can anyone help me?

Thanks in Advance 

 

Labels (2)
11 Replies
TRF
Champion II
Champion II

I strongly suggest you to try the suggested approach.

3 million records per week, not a so huge volume, and Talend is very fast with this kind of files, it could be a good solution despite of the opposition regarding the i/o operations.

Else, you will have to play with tFlowToIterate / tLoop / tIterateToFlow to build the right algorithm.

Anonymous
Not applicable
Author

Thanks TRF

 

tFlowToIterate / tLoop / tIterateToFlow

 

how to use mentioned component and where ?