Concatenation of tables using loop

[madushanfernand]

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

 

Content of a table

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

[marcus_malinow]

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

[pradosh_thakur]

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

[agni_gold]

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Sc...