topic Re: Load Script Looping from a designated date forward in QlikView

Load Script Looping from a designated date forward

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

All,

I have a list of QVDs (CWR Transform 201610.qvd, CWR Transform 201611.qvd, CWR Transform 201612.qvd, etc) that I am trying to load and concatenate together into a single table. There are many of these qvd files in the folder and I olny want to load the ones 201611 forward.

The file path for the qvds is

\\us1sawn03108\CWR\03_QVD\CWR Transform 201701.qvd]

Suggestions?

Re: Load Script Looping from a designated date forward

ger_alegria — Tue, 28 Feb 2017 22:01:01 GMT

You can try with something like this:

Set vYearMonthStart = 201611;

Set vYearMonthEnd = 201703; //This variable is the last month you have data

For i = $(vYearMonthStart) to $(vYearMonthEnd) step 1

Load *

From \\us1sawn03108\CWR\03_QVD\CWR Transform i.qvd];

Re: Load Script Looping from a designated date forward

brf10043 — Tue, 28 Feb 2017 23:10:06 GMT

So when I load from a specific qvd file the load is successful.

Set vCWRYearMonthStart = 201611;

Set vCWRYearMonthEnd = 201701; //This variable is the last month you have data

For i = $(vCWRYearMonthStart) to $(vCWRYearMonthEnd) step 1;

Load *
From
[\\us1sawn03106\SourceDocuments\CWR\03_QVD\CWR Transform 201701.qvd]
(qvd);

However when I load CWR Transform i.qvd I get a "Cannot open file '\\us1sawn03106\SourceDocuments\CWR\03_QVD\CWR Transform i.qvd' The system cannot find the file specified." Error message. What am I missing?

Re: Load Script Looping from a designated date forward

sasiparupudi1 — Wed, 01 Mar 2017 12:05:34 GMT

[\\us1sawn03106\SourceDocuments\CWR\03_QVD\CWR Transform i.qvd]

[\\us1sawn03106\SourceDocuments\CWR\03_QVD\CWR Transform $(i).qvd]

Re: Load Script Looping from a designated date forward

sasiparupudi1 — Wed, 01 Mar 2017 12:46:02 GMT

Try

Let vCWRYearMonthStart = Date(MakeDate(2016,11,1),'YYYYMM') ;

Let vCWRYearMonthEnd =Date(MakeDate(2017,1,1),'YYYYMM'); //This variable is the last month you have data

trace >> CWR Transform $(vCWRYearMonthStart).qvd;

Let vCWRYearMonthStart =Date(Addmonths(Date#($(vCWRYearMonthStart),'YYYYMM'),1),'YYYYMM') ;

Loop while $(vCWRYearMonthStart)<=$(vCWRYearMonthEnd);