Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ioannagr
Creator III
Creator III

Concatenate tables with for statement script

Hi, 

I made qvds by year, so i have Qvd-1, Qvd-2, Qvd-3,... Qvd-20.

I want to concatenate them into a final qvd

Set i=1;

For each i in Qvd-'($i)'

Concatenate;

Set i=i+1;

next;

is that correct?

1 Reply
Dalton_Ruer
Employee
Employee

Did you try simply using a wildcard in the FROM clause

FROM [lib://{YourLibConnector}/Qvd-*.qvd] (qvd);