Currency exchange within incremental load

Ask a Question

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

0 Replies