Cannot load qvd if field does not exist

[#1]

I would like to load qvd files, some with a particular field, some without.  When I try to load qvd files without the field, the file does not load.  How can I load a qvd that has a missing field?

[IAMDV]

Hi Nancy,

I'm not sure why you wanted to load the fields when they are not available in the QVD files. However, you can create psuedo fields by using the static values or NULL() function if you want them as NULLs. Here is the example...

LOAD

      CustomerKey,
     GeographyKey,
     CustomerLabel,
     Title,
     FirstName,
     MiddleName,
     LastName,
     EmailAddress,
     NULL() as DV_Test
FROM
[..\Test.QVD]
(qvd);

I hope this helps!

Cheers,

DV

www.QlikShare.com

[kaushiknsolanki]

Hi,

     What i understood is while fetching the data you want to list down the fields which you want in some cases and in some cases you dont want.

     Try this way.

     Load Field1, Field2 from xyz;  For listing field name.

     Or

     Load * from xyz; for fetching all fields.

Regards,

Kaushik Solanki

[Anonymous]

I have the same problem.

You cannot load all files in a directory, if a single one is missing a single field that all others have.

A quite common thing to happen during developement.

Where is the solution?

[prieper]

LOAD * FROM A ....

CONCATENATE LOAD * FROM B ...

etc.

fields not needed might be dropped or renamed.

Peter