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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Iterate through file list for every item of another file list

Hi,
I have the following problem: I have two lists of files. For every item of the first list I try to iterate throug all items of the second list and look for matching attribute value.
Example:
File list 1:
A.xml
B.xml
C.xml
D.xml
File list 2:
1.xml
2.xml
3.xml
-> compare A.xml with 1.xml, 2.xml, 3.xml
-> compare B.xml with 1.xml, 2.xml, 3.xml
-> compare C.xml with 1.xml, 2.xml, 3.xml
-> compare D.xml with 1.xml, 2.xml, 3.xml
The problem in the job you can see in the attached screenshot is the arrangement of the two filelists. How to arrange it, so that the second list is traversed for every item of the first list?
0683p000009MDeZ.png 0683p000009MDaO.png
Labels (3)
3 Replies
willm1
Creator
Creator

ohofrichter - how about this?
As you can see in the drop down list, you can access the global variables for both tFileList1 and tFileList2...
0683p000009MDWm.png
Anonymous
Not applicable
Author

Thank you, willm. It works!
willm1
Creator
Creator

ohofrichter - glad to hear 0683p000009MACn.png
Please mark this post as resolved.
Thx...