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: 
reinier1
Contributor III
Contributor III

iterating files using tFileList only processes last file

I have the following config:

 

tFileList > iterate > tFileInputPositional > Schemacheck > tMap > tFileOutputDelimited

 

There are 2 files in the file list. when running the job it states '2 execs finished' on the iterate connector. However, from tFileInputPositional, only the last file is processed.

 

What am I missing?

Labels (3)
4 Replies
TRF
Champion II
Champion II

Can you share tFileInputPositional and tFileInputPositional settings?
reinier1
Contributor III
Contributor III
Author

 

Like this?

0683p000009M6ci.png

 

 

0683p000009M85B.png

TRF
Champion II
Champion II

Nothing special in the settings.
Are you sure both files have the same schema?
reinier1
Contributor III
Contributor III
Author

I found the issue(s):

 

- The row count after the tFileInputxx is the rowcount of the last file, not the total

- I had been playing with the 'append' option of the tFileOutputxxx. It was greyed out for me and said that the property was managed by the Repository (where I could not find that option at ll). When I switched the Property Type from Repository to Built-In *and back*, now I could select Append, and I find all my records in the outputfile.

 

Thanks for the (moral) support.