topic Re: Using For Loop in App Development

Using For Loop

sowmi — Sat, 16 Nov 2024 03:14:46 GMT

Hi everyone ,

I'm using for loop when loop runs date variables should be updated here is the scrip i am using below script but variables are updated but in my min-max table it is only showing the first start two dates in my dates file i have dates like 1/2/16,1/9/16,1/16/16

Tmp:
Load Date from file1
;

FOR i =1 to FieldValueCount('Date')-1

LET vDate_0 = Peek('Date', $(i),'Tmp');

LET vDate_1 = WeekStart(vDate_0+7);

Min_Max:
Load
Date( '$(vDate_1)') as Max_Date,
Date('$(vDate_0)') as Min_Date
Resident Tmp;
NEXT i;

when i run the loop i am excepting to see Max_Date as 1/16/16 and min date as 1/9/16.

Thnxs

Sowmi

Re: Using For Loop

Prashant_Naik — Tue, 18 Feb 2020 11:50:08 GMT

Hi,

Can you provide us a sample data and expected result from it, then it will be more clear to write script.

Regards,

Prashant

Re: Using For Loop

sowmi — Tue, 18 Feb 2020 13:16:44 GMT

Hi ,

Date is weekly based starting from 1/4/2016 to 12/26/2016 ,when first loop runs min date should be 1/4/2016 and max should be 1/11/2016 min and max values should be changing when loop runs and needs to be stored in a variable so i can use them for further calculations.

Re: Using For Loop

Prashant_Naik — Tue, 18 Feb 2020 14:11:07 GMT

Hi,

This might help

Tmp:
Load distinct Date from file1
;

Let vNoofrows = NoOfrows ('Tmp');
FOR i =1 to $(vNoofrows)-1

LET vDate_0 = Peek('Date', $(i),'Tmp');

LET vDate_1 = WeekStart(vDate_0+7);

Min_Max:
Load

Date,
Date( '$(vDate_1)') as Max_Date,
Date('$(vDate_0)') as Min_Date
From file1 where Date = '$(vDate_0)';
NEXT i;

Drop table TMP;

This will loop so many times which will hit the performance.

Regards,

Prashant