topic Re: Load multiple excel files from Multiple excel sheets in QlikView

Load multiple excel files from Multiple excel sheets

Nagaraju_KCS — Fri, 06 Sep 2013 04:45:45 GMT

Hi Community,

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

Thanks..

Re: Load multiple excel files from Multiple excel sheets

tresB — Fri, 06 Sep 2013 04:55:35 GMT

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

Re: Load multiple excel files from Multiple excel sheets

Nagaraju_KCS — Fri, 06 Sep 2013 05:16:25 GMT

Hi Tresesco,

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

Re: Load multiple excel files from Multiple excel sheets

tresB — Fri, 06 Sep 2013 05:22:59 GMT

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.

Re: Load multiple excel files from Multiple excel sheets

rwunderlich — Fri, 06 Sep 2013 05:26:26 GMT

How about "LOAD *"?

-Rob

Re: Load multiple excel files from Multiple excel sheets

Nagaraju_KCS — Fri, 06 Sep 2013 05:31:56 GMT

Hi,

Please find attached files...

Re: Load multiple excel files from Multiple excel sheets

Sat, 07 Sep 2013 04:08:41 GMT

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).

Re: Load multiple excel files from Multiple excel sheets

gajapathy74 — Sat, 07 Sep 2013 10:10:45 GMT

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);

Re: Load multiple excel files from Multiple excel sheets

Nagaraju_KCS — Sat, 07 Sep 2013 14:11:37 GMT

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