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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
JacobLag
Contributor
Contributor

QlikView Load Script - Weekly CSV-File - Fieldname changed

Hello Everybody,

I'm looking for a solution regarding following Problem:

Currently we are loading every monday a CSV file from a public health insitute with certain data, by using a fileliste (For Each file in FileList ). Thats working very fine. But since the last week, one specific fieldname was slightly changed by the insitute. Example:

Fieldnames of old CSV Files: A | B | C

Fieldnames of new CSV Files: A | X | C

So for the new CSV files, I get the error "Field B" does not exist. Is there a simple solution within the loading script for loading the filelist and checking whether Fieldname 'B' exists, and if not, then load Fieldname 'X'?

Best regards,

Jacob

Labels (3)
0 Replies
Community Browser