Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have tried to create a loop to load files, it works except for the part where its supposed to identify if the file exists and just carry on if it doesn't...can anyone help please.
let vSYear=2016;
let vSMonth=6;
let vSPe=$(vSYear)&
if($(vSMonth)<10,'-0','-')
&$(vSMonth);
let vEYear=year(now());
let vEMonth=num(month(now()),'0');
let vEPe=$(vEYear)&
if($(vEMonth)<10,'-0','-')
&$(vEMonth);
set a='$(vSPe)';
Do While a<'$(vEPe)'
Let vDs=1;
Do While vDs<=31
let vDss=if($(vDs)<10,'-0','-')
&$(vDs);
SET vFileName1='
LET $(vFileExsist1)=isnull(QvdCreateTime('$(vFileName1)'));
//Let vFileExsist=if(FileSize($(vFileName))>0,-1,0);
SET vFileName2='
Let $(vFileExsist2)=isnull(QvdCreateTime('$(vFileName2)'));
//Let vFileExsist=if(FileSize($(vFileName))>0,-1,0);
if $(vFileExsist1)=0 then
t_tmp:
LOAD DateTime as StartDate,
ClientIdNo,
[Age Group],
Amount,
TxId,
Product
FROM
(qvd);
End if
if $(vFileExsist2)=0 then
Concatenate (t_tmp)
LOAD DateTime as StartDate,
ClientIdNo,
[Age Group],
Amount,
TxId,
Product
FROM
(qvd);
End if
let vDs=$(vDs)+1;
loop
And if you don't create a variable and you write this before "t_tmp:"
IF not IsNull(FileSize('$(vFileName1)')) then ...
This line:
>>LET $(vFileExsist1)=isnull(QvdCreateTime('$(vFileName1)'));
Should read:
LET vFileExsist1 = Not(isnull(QvdCreateTime('$(vFileName1)')));
Similarly
>> Let $(vFileExsist2)=isnull(QvdCreateTime('$(vFileName2)'));
Should read:
LET vFileExsist2 = Not(IsNull(QvdCreateTime('$(vFileName2)')));
(make sure that you use consistent spelling of the varables..)
ok, but the problem is that there are 2 if statements, and it has issues with the fact that i am not ending them, have tried 'EndIf' and 'End if'
Thanks for the help will try and see anyways
Awesomeness, this works...thanks