Discussion Board for collaboration related to QlikView App Development.
I don' t seem to find the answer to this.
I want to load multiple CSV files, in which the columns are named, but some of them miss some columns
file 1 to n have columns (a,b,c,d)
file n+1 to p have columns (a,b,c,d,e)
if my load scripts tries to read column 'e' I get an error for files 1 to n.
How can I prevent this?
Thanks in advance
Thank you, I get your idea, but this seems an overkill for my case.
Is there really no way in Qlikview load scripts to do something like this
a as [field a],
b as [field b],
c as [field c],
d as [field d],
if (e exists, e, null) as [field d]
There is no way inside from a load to check if fields are existing or not. The easiest way would be the suggestions below from maxgro- use it, it's easy.