Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rohitk1609
Master
Master

Nest For loop not working

Hi Techies,

I am using nested loop, where two are my for loop and one is Do while, It only executes once, then second time it get fails and give me me error as The control statement is not correctly matched with its corresponding start statement

               Next a

Temp_0:

load

*

Inline

[

FIELD_CATEGORY

ABC/

CDE/

EFG/

](delimiter is '/');

Let c=1;

FOR c = 1 to  NoOfRows('Temp_0')-1

TEMP:

Load

*

inline

[

FIELD

ABC

DEF

GHI

];

let a=1;

FOR a = 1 to NoOfRows('TEMP')-1

let Var=FieldValue('FIELD',$(a));

let vCountry = SubField(Var,'|',2);

////////Weekly Loop///////

let vToday = num(now())-14;

let b= '42442';

Do while b <= vToday

let vmessage='';

let b=b+7;

Loop

NEXT a

Next c

what I am trying to do, my code first take value from first inline table , then take value from second inline table and then run the weekly loop from a certain date and same repeat for other values from inline table

1 Reply
rohitk1609
Master
Master
Author