Pulling data from multiple qvds with a missing field in few

[sanp96]

Hello everyone,

I'm still in the process of getting fully familiar with QlikSense and it would be great if anyone could help me out with this issue. I am pulling data from multiple qvds (one for each store) which are stored as a similar structure and format. 

My load script looks something like this: 

Load StoreNumber

StoreName,

...

InsuranceCost,

InsuranceName

From[filepath.../VehicleSales_*.qvd](qvd);

The issue with this is not all the qvds have the field 'InsuranceName' and hence I get the field not found error, and I'm unable to load any data. I cannot simply exclude that field because I need it for analysis.

Does anyone know a way to do this? Any help/suggestion is highly appreciated.

Thanks!

[Vegar]

what if you start by loading all fields with star (*).

for each _file in filevaluelist('filepath.../VehicleSales_*.qvd')

Load *

From[$(_file)](qvd);

next  _file

Afterward you can drop the fields that you don't need or do a NoConcatenate load of the fields that you do need.