Hi everyone,
I have two tables with join:
1. [Chile]:
LOAD
"Exchange Rate Date",
"Savings Amount (Local Currency)"
FROM [.............]
(ooxml, embedded labels, table is Chile);
2. Join([Chile])
LOAD
Exchange Rate Date,
Country as CurrencyCountry,
Rate as "CurrencyRate"
FROM [............]
(ooxml, embedded labels, table is CLP);
I would like to create another column in the table Chile:
[Savings Amount (Local Currency)] * [CurrencyRate] as Savings Amount (USD)
Because I use Join for different tables I cannot use the field 'CurrencyRate' in the Chile table.
Please help me to do it!