How to read all the Qvds with name difference(date) in a loop ??

[vishalgoud]

Hi Team ,

Need Urgent help : we have 18 Qvds of same name the only difference is month and year. like xyz_20160101 and xyz_20170601 etc. i have to load last 12 qvds.(aug-16 to Jul-17)

date format : xyz_yyyymmdd.

1. i want to write a loop condition to load all these last 12 qvds.

2. also i want to extract the new qvds from db with changed strcture(just new columns are added) now i have to concatinate the both old and new extracted qvds and save them on the same path from where we took old qvds.(overwritting the old qvds).

// Old Qvd

LOAD Date,
[Customer ID],
Sal
FROM
                          // this has to be loaded 12 times
(qvd);

// New Qvd with additional columns
LOAD Date,
[Customer ID],
Sal,
Rating,
Cycle
FROM
(qvd);             // we have to extract the 12 new qvds and concatinate with the old qvds and overwrite in the old qvds path.

Please help me as this has to done very urgently. Thanks

[jpenuliar]

YOu probably can use a for loop:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptControlS...

[jpenuliar]

or a For Each ... Next Loop:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptControlS...

[aarkay29]

may be

Table:

'' as Dummy;

Concatenate

LOAD *

FROM

(qvd);

Drop Field Dummy;