Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
debabrata_sahoo
Contributor III
Contributor III

How to load data from multiple table with single load statement.

We  have 4 tables named A1,A2,A3 and A4 , here all 4 tables having same data then How we load all 4 tables in a single load statement. If its possible or any one know please help me out.

 

 

Thanks in advance

Debabrata

2 Solutions

Accepted Solutions
NW1965
Creator
Creator

Just use wildcard in your load statement as follows:

 

TableName:

Load A, B, C, D FROM A*.XLSX;

 

 

View solution in original post

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

The question is from where are you loading the data?
If data format is csv or xslx or xls or qvd, and all the files are in the same catalog then simple use
From *.xslx as mentioned above:
LOAD *
From
[C:\5.Data\*.qvd]
(qvd)
;
If the source is different than "it depends" 🙂

View solution in original post

9 Replies
NW1965
Creator
Creator

Just use wildcard in your load statement as follows:

 

TableName:

Load A, B, C, D FROM A*.XLSX;

 

 

Shubham_Deshmukh
Specialist
Specialist

Hey NW1965,
It doesn't work with xlsx, I tried it.
kevincagle
Contributor III
Contributor III

Are all the tables in the same workbook on different sheets or are they all independent files?

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

The question is from where are you loading the data?
If data format is csv or xslx or xls or qvd, and all the files are in the same catalog then simple use
From *.xslx as mentioned above:
LOAD *
From
[C:\5.Data\*.qvd]
(qvd)
;
If the source is different than "it depends" 🙂
NW1965
Creator
Creator

It really does work 🙂

This is my load script, it loads three files called a1.xlsx, a2.xlsx and a3.xlsx

LOAD A, B
FROM [Z:\a*.xlsx]  (ooxml, no labels, table is Sheet1);

debabrata_sahoo
Contributor III
Contributor III
Author

Yes its working on multiple excel file. 

debabrata_sahoo
Contributor III
Contributor III
Author

if A1,A2,A3 and A4  will different sheet of one excel file then what we have to do.

Shubham_Deshmukh
Specialist
Specialist

Means in filename "5", it will take all sheets on by one right?