Load multiple excel files from Multiple excel sheets

[Nagaraju_KCS]

Hi Community,

Load multiple excel files from Multiple excel sheets, but i have same diffrent column field

Thanks..

[tresB]

I guess these links would be helpful.

http://community.qlik.com/message/258417#258417

http://community.qlik.com/thread/61585

http://community.qlik.com/blogs/qlikviewblogs/archive/2008/09/29/loading-multiple-excel-sheets.aspx

[Nagaraju_KCS]

Hi Tresesco,

It's fine, but i don't have same columns.. that's why  i have problem

[tresB]

If you don't have same columns, you would have different tables(because they won't be auto concatenated). That is what the difference would be I believe. Or, if you are trying to achieve something else, please explain.

[rwunderlich]

How about "LOAD *"?

-Rob

[Nagaraju_KCS]

Hi,

Please find attached files...

[#7]

Hi

try this

open Qlik view-> Ctrl+E click ->Table files Select Your File.

Select one sheet then again load same file select other sheet (The window open like above).

[gajapathy74]

I have given below the script load data from Read.XLSX file. let me know what is the common field (or) the field (/column) that you want to link between Employee/Office to the field (column) in the Read file.

READ_Tbl:

LOAD Name,

     Born,

     Country,

     Tests,

     ODIs,

     T20s

FROM

READ.xlsx

(ooxml, embedded labels, table is India);

LOAD Name,

     Born,

     Country,

     Tests,

     ODIs,

     T20s

FROM

READ.xlsx

(ooxml, embedded labels, table is ENG);

LOAD Name,

     Born,

     Country,

     Tests,

     ODIs,

     T20s

FROM

READ.xlsx

(ooxml, embedded labels, table is NZ);

[Nagaraju_KCS]

Hi Jagapathy,

This is not a correct way. i want to load at a time..

see this link  http://community.qlik.com/message/258417#258417