Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
swapnahari
Contributor
Contributor

Dynamic variable

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

1 Reply
MayilVahanan

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.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.