How to include included variable in new table

[#1]

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);

Next

[rwunderlich · Accepted solution]

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

[#3]

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