Creating Dynamic URL in Load Editor (Almost There?)

caseyjohnson — Tue, 11 Sep 2018 17:49:26 GMT

Trying to get info from a Web File Data Connection that needs a dynamic URL. I'm almost there but I'm only able to get the first page of results. The script is reading the dynamic url from the table, but it's not moving on to the next URL. I'm trying to get data from the first (2) pages of data from each different URL may have (few to many). Here's what I have (thanks to this thread ["Load" within a for loop with passing dynamic v... | Qlik Community]‌). I think I'm close and my issues are in the For statements?

[Table A]: // has the info needed for the dynamic url

LOAD

"Field A"

FROM [ .....]

(...);

For x = 1 to NoOfRows('Table A')-1

Let fieldA = FieldValue('Field A', $(x));

For i = 1 to 2 step 2 // to toggle through first two pages, think this is my issue ??????

[Table B]:

"Field B",

"Field C",

'$(fieldA) // want this info in data output

FROM [lib:// ....]

(url is [http://www.abc.com/search/$(fieldA)/page=$(i)] html, embedded labels, table is @3);

Next i;

Re: Creating Dynamic URL in Load Editor (Almost There?)

caseyjohnson — Wed, 19 Sep 2018 15:55:20 GMT

Got this to work for one variable, not the multiple variables (for pages yet).