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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Code Flexibility

I have a script that loads CSV files from a directory like:

Load '' as TmpField AutoGenerate 0;

Concatenate Load

Price,

Date,

Retailer,

...

From \\FilePath\*.CSV

Drop Field TmpField;

If a new CSV file comes with an additional field that is not present in any of the existing files and I add that in the code above, it fails because that field does not exist in current CSV files.

Is there a way to have that additioanl field in the script and avoid it from failing?

I know Load * could be an option but I was seeing if there's another alternative.

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

I don't think there's a practical alternative. I'd use load * and if that pulls in some unwanted fields, well those can be dropped afterwards with drop field x,y, etc;.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Thanks.