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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Iterate tFileList for each file in another tFileList

Hi all,

 

i have the following job:

 

0683p000009M80X.png

I need to iterate the tFileList_1 for each file il tFileList_2, because i need to match if the file in the folder of tFileList_1 have the same content of the file present in the folder of tFileList_2.

My job as you see in the image, is not working properly, because the iteration work simultaneously.

 

Any suggestion?

 

Thanks in advance

Nicola

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi Nicola,

 

    Since you have to quickly check whether file A and B are matching based on the conditions, the best way is to do the comparison using tFileCompare component.

 

    Now, if you have to compare multiple input files with multiple lookup files, you will have to loop them in multiple iterations. In the below loop, the input file from FileList1 will be compared in recursive manner with FileList2 files and will provide the output.

 

0683p000009M2Bt.png

 

      Could you please try this method? You can either match in text or binary mode.

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hi Nicola,

 

    Since you have to quickly check whether file A and B are matching based on the conditions, the best way is to do the comparison using tFileCompare component.

 

    Now, if you have to compare multiple input files with multiple lookup files, you will have to loop them in multiple iterations. In the below loop, the input file from FileList1 will be compared in recursive manner with FileList2 files and will provide the output.

 

0683p000009M2Bt.png

 

      Could you please try this method? You can either match in text or binary mode.

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Anonymous
Not applicable
Author

Hi Nikhil,

thank you, the solution works perfectly!

Many thanks
Warm Regards
Nicola Bracchini