Qlik Community

App Development

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

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
madushanfernand
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
marcus_malinow
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.

pradosh_thakur
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.