topic Re: No labels applicable on QVD files? in QlikView

No labels applicable on QVD files?

Wed, 17 Aug 2016 11:02:10 GMT

Hi there,

I was trying to apply "No Labels" on a QVD file in a LOAD script.

Hereby the script;

LOAD

A as [Customer],

B as [Adres]

FROM

[..\*qvd] (no labels, qvd);

I expected this would work in a similar way as with other filetypes (xlsx, csv, txt etc). There are various ways to get the desired result but I was wondering if want I am trying to do is even possible or am I missing something in the script?

PS: Thanks to everybody contributing on this forum, it helped me a lot learning about Qlikview, SQL etc.

Re: No labels applicable on QVD files?

jonathandienst — Wed, 17 Aug 2016 11:25:41 GMT

A qvd is a complete representation of a QV table, including values as well as the field names and data types. You can alias the columns, but you cannot refer to the columns as A,B ... or @1, @2, ... The no labels qualifier will be ignored.

So if the QV contains 2 fields named Cus and Add, you could load with

LOAD

Cus as [Customer],

Add as [Adres]

FROM

[..\*qvd] (qvd);

Re: No labels applicable on QVD files?

Wed, 17 Aug 2016 11:45:06 GMT

Hi Jonathan, Thank you for confirming!