Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
I have a data with
Load
"Survey External ID",
Num(Month(Min(Survey_Date))) as MinDate,
Min(Survey_Date) as Min_Date
Resident [Survey_Data] Group By "Survey External ID";
NoConcatenate
Date:
Load
MinDate,
varMaxDate - MinDate as Diff
Resident Max ;
Let vMaxDate = Peek('varMaxDate',0,'Max');
Let Dt = (NoOfRows('Date')-1);
For a =0 to Dt
Let vMinDate = Peek('MinDate',a,'Max');
Next a;
a is not incrementing can you please help.
Thank you
Hi @swapnahari
Can you give a sample data and inform what u are trying to achieve? so that, its easy for us to verify it.