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

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

vishalgoud — Wed, 25 Nov 2020 16:16:04 GMT

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

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

jpenuliar — Tue, 14 Nov 2017 16:46:42 GMT

YOu probably can use a for loop:

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

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

jpenuliar — Tue, 14 Nov 2017 16:47:14 GMT

or a For Each ... Next Loop:

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

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

aarkay29 — Tue, 14 Nov 2017 16:58:23 GMT

may be

Table:

'' as Dummy;

Concatenate

LOAD *

FROM

(qvd);

Drop Field Dummy;