Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
caseyjohnson
Contributor III
Contributor III

Creating Dynamic URL in Load Editor (Almost There?)

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;

1 Solution

Accepted Solutions
caseyjohnson
Contributor III
Contributor III
Author

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


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

LOAD

"Field A"

FROM [ .....]

(...);

For each x in FieldValueList('Field A')

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/$(x)/page=1] html, embedded labels, table is @3);

Next x;

View solution in original post

1 Reply
caseyjohnson
Contributor III
Contributor III
Author

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


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

LOAD

"Field A"

FROM [ .....]

(...);

For each x in FieldValueList('Field A')

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/$(x)/page=1] html, embedded labels, table is @3);

Next x;

View solution in original post