topic How to load from a dbf which is missing a field in QlikView

How to load from a dbf which is missing a field

Mon, 19 Jan 2015 08:54:10 GMT

Hello

i have to load data from a multiple table, which is quite identical, but one of them is missing a field , let's say country. i load in a loop, so the it's arrive at the problem one he just gave an erros and stops, is there a way to check at loading if the field exist and loading a default value . i have try: iif(TYPE("country")='none',country) as country.

Thank you

Re: How to load from a dbf which is missing a field

Mon, 19 Jan 2015 09:03:55 GMT

from what i realized the problem is not in the fir part of iif, because if i put after = 'none','other', it work whithout an error, but he try to evaluate contry although he should not.

Re: How to load from a dbf which is missing a field

MarcoWedel — Mon, 19 Jan 2015 09:11:44 GMT

Hi,

you could load using "LOAD *" and "concatenate" to load all fields and concatenate into one table

Hope this helps

Regards

Marco

Re: How to load from a dbf which is missing a field

Mon, 19 Jan 2015 09:34:53 GMT

i have try it but id does not work , because this table is in 17 data source , and from each source i have to load from every month of the last 3 years so i use a repetitive comand with a for i to ....