topic Re: Concatenation of tables using loop in App Development

Concatenation of tables using loop

madushanfernand — Tue, 29 Jan 2019 11:37:02 GMT

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

Re: Concatenation of tables using loop

marcus_malinow — Tue, 29 Jan 2019 11:48:31 GMT

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

Re: Concatenation of tables using loop

pradosh_thakur — Tue, 29 Jan 2019 11:50:58 GMT

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/td-p/1304212

Re: Concatenation of tables using loop

agni_gold — Tue, 29 Jan 2019 11:51:59 GMT

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptControlStatements/For%20Each.htm