Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New 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
Contributor

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

Just use wildcard in your load statement as follows:

 

TableName:

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

 

 

View solution in original post

Highlighted
Valued Contributor III

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

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
Contributor

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

Just use wildcard in your load statement as follows:

 

TableName:

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

 

 

View solution in original post

Highlighted
Valued Contributor

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

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

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

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

Highlighted
Valued Contributor III

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

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

Highlighted
Contributor

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

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

Highlighted
New Contributor III

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

Yes its working on multiple excel file. 

Highlighted
New Contributor III

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

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

Highlighted
Valued Contributor III

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

Highlighted
Valued Contributor

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

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