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
