Dear all,
I came up with the following solution to do incremental load and keep the Price and Quantity "unchanged" (attached).
I am trying to to implement a currency exchange table e.g.
ExchangeRate:
LOAD * Inline [
ID, Currency, Rate, Date
1, CAD, 0.11, 01.01.2017
2, CHF, 0.22, 02.01.2017
3, CNY, 0.33, 03.01.2017
4, GBP, 0.44, 04.01.2017
5, JPY, 0.55, 05.01.2017
6, USD, 0.66, 06.01.2017
7, USD, 0.77, 10.01.2019
];
Unfortunately, I have 2 issues:
- I must convert the Price field based on rates in the script.
- I have to save the new price and keep it unchanged, so in case the exchange rate changes, it should affect the new added rows, but not the old ones.
I will be glad if you can share your ideas with me.
Thanks in advance
Ahmed