topic Re: Field not found error in QlikView

Field not found error

qvqfqlik — Wed, 29 Jun 2016 17:07:39 GMT

I am trying to create qvd - reading fields from excel.

Emptyqvd:

LOAD a,

From c:\file.xls

store Emptyqvd into c:\abc.qvd(qvd);

Error : filed not found

but I want the format of that field to be "" (with squarebrackets)

spreadsheet has field a,

Please help

Re: Field not found error

sunny_talwar — Wed, 29 Jun 2016 17:26:40 GMT

May be try this:

Emptyqvd:

LOAD a, []

From c:\file.xls

store Emptyqvd into c:\abc.qvd(qvd);

Re: Field not found error

sunny_talwar — Wed, 29 Jun 2016 17:28:17 GMT

Or this:

Emptyqvd:

LOAD a, ""

From c:\file.xls

store Emptyqvd into c:\abc.qvd(qvd);

Re: Field not found error

qvqfqlik — Wed, 29 Jun 2016 17:48:02 GMT

Its not working.

I have the same syntax in the actual cide where the qvd is getting created

. Im trying to create an empty qvd with the same field names as in one of the existing qvds

Re: Field not found error

antoniotiman — Wed, 29 Jun 2016 18:15:25 GMT

Can You try

Load * from ...... ?

Re: Field not found error

trdandamudi — Wed, 29 Jun 2016 18:23:11 GMT

Just do a Load * and you will get it:

Table1:

LOAD *

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Field not found error

antoniotiman — Wed, 29 Jun 2016 18:32:45 GMT

You can also try

LOAD @1 as A,
@2 as B
FROM
[Cartel2.xls]
(biff, no labels, header is 1 lines, table is Foglio1$);

Re: Field not found error

trdandamudi — Wed, 29 Jun 2016 18:33:00 GMT

Prithvi,

Sunny's solution works take a look at the attached files:

Emptyqvd:

LOAD a,

FROM

(ooxml, embedded labels, table is Sheet1);

store Emptyqvd into C:\Temp\Community\FieldNameWithSquareBracketEnclosed.qvd(qvd);

Please cross check and see if you are missing something .. Hope this helps.