Field not found error

[qvqfqlik]

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

[sunny_talwar]

May be try this:

Emptyqvd:

LOAD a, []

From c:\file.xls

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

[sunny_talwar · Accepted solution]

Or this:

Emptyqvd:

LOAD a, ""

From c:\file.xls

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

[qvqfqlik]

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

[antoniotiman]

Can You try

Load * from ......  ?

[trdandamudi]

Just do a Load * and you will get it:

Table1:

LOAD *

FROM

(ooxml, embedded labels, table is Sheet1);

[antoniotiman]

You can also try

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

[trdandamudi]

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.