topic How to include included variable in new table in QlikView

How to include included variable in new table

Tue, 18 Oct 2016 23:17:57 GMT

I have the following script that inserts a variable into a web page and then pulls data. How can I include the variable that I am injecting into the string into each pull? So for instance, if PDGA Number is 1 then I would want PDGA Number 1 inserted into the tournament detail table. This way I can join the two tables together by PDGANumber.

Set a = 'PDGANumber';

set ErrorMode=0;

PlayerStats:

LOAD Team,

Player,

PDGANumber,

FirstRating,

Driving,

Approach,

Putting

FROM

(ooxml, embedded labels, table is D2);

For each a in FieldValueList('PDGANumber')

TournamentDetail:

LOAD Tournament,

Date,

Round,

Score,

Rating,

Included

FROM

[http://www.pdga.com/player/$(a)/details]

(html, codepage is 1252, embedded labels, table is @1);

Re: How to include included variable in new table

rwunderlich — Tue, 18 Oct 2016 23:36:52 GMT

Add a reference to $(a) into your TournamentDetal LOAD.

TournamentDetail:

LOAD Tournament,

'$(a)' as PDGANumber,

Date,

Round,

Score,

Rating,

Included

FROM

[http://www.pdga.com/player/$(a)/details]

(html, codepage is 1252, embedded labels, table is @1);

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: How to include included variable in new table

Tue, 18 Oct 2016 23:41:34 GMT

Thank you, sometimes it is so simple I try and over complicate it and overlook the solution.....