topic Re: Table load from excel in QlikView

Table load from excel

vikasgupta — Mon, 18 Mar 2013 10:58:47 GMT

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

Mon, 18 Mar 2013 11:25:46 GMT

Hi vikas,

PFA, Hope needful; has been done.

Nirmal

manideep78 — Mon, 18 Mar 2013 11:28:05 GMT

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,

"2"

FROM

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

(ooxml, embedded labels, table is Sheet1);

See attached qvw file

Hope this helps

Thanks

Manideep

Mon, 18 Mar 2013 11:35:11 GMT

Hi,

Try this

LOAD Name,

[2]

FROM

(ooxml, embedded labels, table is Sheet1);

er_mohit — Mon, 18 Mar 2013 11:41:02 GMT

LOAD Name,

[2]

FROM

(ooxml, embedded labels, table is Sheet1);

WRITE in this way [2]

hope it helps