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

[debabrata_sahoo]

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

[NW1965 · Accepted solution]

Just use wildcard in your load statement as follows:

TableName:

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

[Shubham_Deshmukh]

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

[kevincagle]

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

[MindaugasBacius · Accepted solution]

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]

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]

Yes its working on multiple excel file. 

[debabrata_sahoo]

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

[MindaugasBacius]

Please study this page:
https://community.qlik.com/t5/QlikView-Scripting/Loading-Multiple-Excel-Files-and-Multiple-Excel-she...

[Shubham_Deshmukh]

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