Table load from excel

[vikasgupta]

Hi

I wants to load a table from excel sheet where some column name are in numeric so after importing from excel data is not coming as per table.

so please suggest me what is going wrong .

Thanks

Vikas

[#2]

Hi vikas,

PFA, Hope needful; has been done.

Nirmal

[manideep78 · Accepted solution]

When you give a numeric value as field name, Qlikview automatically assign that value as Record as well as Field.

If you give only 2 it will treat 2 as  data and assign 2 as field name.

So If you give 2 in double quotes it will treat as string.

Keep 2 in Double Codes as Shown in Bold

LOAD Name,

     X,

    "2"

FROM

C:\Users\Manideep\Downloads\Test.xlsx

(ooxml, embedded labels, table is Sheet1);

See attached qvw file

Hope this helps

Thanks

Manideep

[#4]

Hi,

Try this

LOAD Name,

     X,

     [2]

FROM

(ooxml, embedded labels, table is Sheet1);

[er_mohit]

LOAD Name,

     X,

     [2]

FROM

(ooxml, embedded labels, table is Sheet1);

WRITE in this way [2]

hope it helps