topic Re: Cannot load qvd if field does not exist in QlikView

Cannot load qvd if field does not exist

Sat, 06 Apr 2013 12:44:29 GMT

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?

Re: Cannot load qvd if field does not exist

IAMDV — Sat, 06 Apr 2013 23:45:41 GMT

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,

www.QlikShare.com

Re: Cannot load qvd if field does not exist

kaushiknsolanki — Sun, 07 Apr 2013 06:03:21 GMT

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.

Load * from xyz; for fetching all fields.

Regards,

Kaushik Solanki

Re: Cannot load qvd if field does not exist

Anonymous — Thu, 04 May 2017 09:25:48 GMT

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?

Re: Cannot load qvd if field does not exist

prieper — Thu, 04 May 2017 10:08:56 GMT

LOAD * FROM A ....

CONCATENATE LOAD * FROM B ...

etc.

fields not needed might be dropped or renamed.

Peter