Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Concatenation of tables using loop

Hi All

I want to concatenate number of tables which are saved in a same folder in qvd format and all the tables are having the same number of fields and same field names as shown as below.

files in folder

Capture1.PNG 

Content of a table

Capture2.PNG

could some one please help me to load and concatenate all of the tables to a single table using a loop?

Thanking in advance

Madushan

3 Replies
Highlighted
Specialist III
Specialist III

If you simply want to load ALL files, a loop is not necessary. Just use a wildcard in the file name.

Highlighted
Master II
Master II

Try below for Qliksense

for each file in filelist('lib://YourConnectionName\*.qvd')

YourTableName:

load

YourField1,

YourField2

from [$(file)](qvd)

next file

If the field name are same it will auto concatenate

The above solution is pre-existing in the community and copy pasted from https://community.qlik.com/t5/Qlik-Sense-Data-Connectivity/Qlik-Sense-Load-all-files-from-a-folder/t...
Learning never stops.
Highlighted