Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys ( stalwar1) ; I wanted to know is there a way to track how many times an application is reloaded in a single day?
In fact, what I'm doing is creating an application to finally store a table into a csv file like follow:
FileName-AsOfDate 2018-02-08
Normally, each day, we create one file; but if the users demand to reload the application a second and a thrid time;
I want to create 2 new files as follow:
FileName-AsOfDate 2018-02-08 V2 (V2=> 2 nd reload of the day)
FileName-AsOfDate 2018-02-08 V3 => 3 rd reload of the day)
is there a way to achieve this?
I would guess that somewhere else in your script you are doing a set ErrorMode=0, but somehow for the Load that fails it actually has not been set.
I did a let ErroMode=0 in the begining of the script and revert it back to 1 only in the last line of the whole script..
Strange...
May be this
LET vDayStart = Today();
If '$(vDayStart)' = If(Len(Trim('$(vDayEnd)')) = 0, 0, '$(vDayEnd)') then
LET vCounter = $(vCounter) + 1;
ELSE
LET vCounter = 1;
ENDIF;
Table:
LOAD * INLINE [
Dim
A
];
LET vSaveFile = Date('$(vDayStart)', 'YYYY-MM-DD')&'V'&$(vCounter);
STORE Table into 'FileName-AsOfDate $(vSaveFile).qvd' (qvd);
LET vDayEnd = Today();
Brilliant Sunny !!