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

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

debabrata_sahoo — Wed, 25 Nov 2020 16:16:04 GMT

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

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

NW1965 — Wed, 20 Feb 2019 10:44:33 GMT

Just use wildcard in your load statement as follows:

TableName:

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

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

Shubham_Deshmukh — Wed, 20 Feb 2019 13:13:07 GMT

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

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

kevincagle — Wed, 20 Feb 2019 14:06:24 GMT

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

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

MindaugasBacius — Wed, 20 Feb 2019 14:07:19 GMT

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" 🙂

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

NW1965 — Wed, 20 Feb 2019 15:38:29 GMT

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

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

debabrata_sahoo — Thu, 21 Feb 2019 04:25:32 GMT

Yes its working on multiple excel file.

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

debabrata_sahoo — Thu, 21 Feb 2019 04:27:34 GMT

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

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

MindaugasBacius — Thu, 21 Feb 2019 05:20:08 GMT

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

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

Shubham_Deshmukh — Mon, 25 Feb 2019 06:38:51 GMT

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