6 Replies Latest reply: Aug 30, 2010 5:37 AM by sharont1964 RSS

    Trouble using variable in the FOR EACH statement rather than a literal

      We would like to substitute the value of the quoted currencies in the FOR EACH statement rather than having a 'closed' list

       

       

      FOR EACH vConvertCurrency IN 'AUD','USD','EUR' // Want to use variable read in from a table here

      RawRate:

      LOAD Replace(@1,'.','/') as Date,

      '$(vConvertCurrency)' as Currency,

      @2 as Rate

      FROM

      [http://www.oanda.com/currency/historical-rates?date_fmt=normal&date=$(vMaxDate)&date1=$(vMinDate)&exch=$(vBaseCurrency)&exch2=$(vBaseCurrency)&expr=$(vConvertCurrency)&expr2=$(vConvertCurrency)&margin_fixed=0&format=HTML&redirected=1]

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

      NEXT