3 Replies Latest reply: Feb 11, 2013 9:45 AM by A B RSS

    Adding calculated field in script

      Hi,

       

      I have a table with orders details, with amount in $.

      Another table with dates and Euro rates per date.

      I would like to calculate the amount in Euro in the load script.

      another words:

      For each order, calculate the amount in Euro, and add the calcuated field in the script.

       

       

      Would appreciate your help.

       

      [Currency Rates]:

      LOAD Date as RateDate,

           USDRate,

            EURRate    

      FROM

      xxx.xls]

       

      [Backlog Orders]:

      LOAD Date as BacklogDate,

           Customer,

           Balance,

           Balance/EURRate as BalanceEUR

             FROM

      YYY.XLS