Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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

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

3 Replies
Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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

Highlighted
Specialist
Specialist

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

may be

Table:

'' as Dummy;

Concatenate

LOAD *

FROM

                         

(qvd);


Drop Field Dummy;