topic Nested For Each loop query in App Development

Nested For Each loop query

rsdhavle — Tue, 01 Oct 2019 11:36:28 GMT

We have a scenario where we are getting number of Ids for different Regions. We need to pass these Id's in URL for one region at the time and We have different URLs for different regions.

Example.

abc.com/xyz/Region1/$(ids)/details

We want to pass set of URLs in a for each loop and at the same time pass Ids specific to that region in above URL. How can we write nested loop for this scenario?

Re: Nested For Each loop query

miskinmaz — Tue, 01 Oct 2019 12:52:38 GMT

You can use the below code

Table1:

Load * Inline [

Id,Region

1,R1

2,R1

3,R2

];

Let vNoOfRows=NoOfRows('Table1');

for i=0 to $(vNoOfRows)-1

Let vRegion= Peek('Region',$(i),'Table1');
Let vID= Peek('Id',$(i),'Table1');

Load

'abc.com/xyz/$(vRegion)/$(vID)/details' as URL,

....

from dataSource

next i;