Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thank you, sometimes it is so simple I try and over complicate it and overlook the solution.....