3 Replies Latest reply: Nov 30, 2011 3:25 AM by Marc Donckers RSS

    How to calculate field in script after joining two tables

    Marc Donckers

      Can someone explain to me how to calculate a field in the script from two fields in a table that is the result of left-joining to load statements?

       

      Here is the simplified script

       

      Tab1:

      Load

           CustomerName,

           InvoiceDate,

           InvoiceValueEuro

      From file1

       

      Left Join Load

           InvoiceDate,

           ExchangeRate

      From file2

       

      What is the next step to add to this table the field InvoiceValueUSD=InvoiceValueEuro*ExchangeRate  ??