I am trying to load a file from website and trying to automate it. I am getting a date variable in the specified format and using it as string in the load script. How to use a variable created in the module in reload script. Trigger part is all completed and stored the variable fdc in specific format (as in the comment in code below) and tested it using msgbox in the module.
Below is the reload script
rem let fdc='2013-11-14';
let fdd ='[http://www.xe.com/currencytables/?from=USD&date=$(fdc)]';
rem fdd is used in load stmt;
LOAD [Currency code ▲▼],
[Currency name ▲▼],
[Units per USD],
[USD per Unit]
FROM $(fdd)(html, codepage is 1252, embedded labels, table is @1);
The above script if I replace fdc with 2013-11-14 as in the comment stmt.
thank you in advance !