Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ??
A simple approach would be a resident load (or store to and load from a qvd) with adding the new field:
Result:
LOAD *, InvoiceValueEuro*ExchangeRate as InvoiceValueUSD
Resident Tab1;
drop table Tab1;
Or you could do a Mapping Load of your Exchangerate table first,
then use applymap function in creation of your new field while loading your value table.
Thanks a lot for both answers. I have tried both solutions, and each works fine.