Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
Load multiple excel files from Multiple excel sheets, but i have same diffrent column field
Thanks..
Hi Tresesco,
It's fine, but i don't have same columns.. that's why i have problem
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.
How about "LOAD *"?
-Rob
Hi,
Please find attached files...
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).
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);
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