QlikView Load Script - Weekly CSV-File - Fieldname changed

JacobLag — Tue, 06 Apr 2021 09:34:51 GMT

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

topic QlikView Load Script - Weekly CSV-File - Fieldname changed in Search the Community

QlikView Load Script - Weekly CSV-File - Fieldname changed