How to calculate exchange rate from a given table

[thunderbolt983]

Hello,

I have got myself this issue, I have a lookup table for static currency exchange rates.
Following are the 2 columns in the lookup table:

Currency
SGD
MYR
INR

Rate
0.720
0.240
0.014

The sales figure is in USD in the main table. So I have to display the exchange rate in 3 new columns in the main table.

Any idea how to accomplish that, I am new to Knime and the Transpose node here doesnt seem to work as I used it in Alteryx. I maybe wrong in pointing out somethings about Knime, correct me if I do.

Thank You.

[armingrudd]

Hi @thunderbolt983,

Do you want to calculate the sales in all these currencies? If yes I think there are more straightforward ways to do that other then adding them as new columns and then calculating sales.

Here is an example workflow which contains 2 cases. One to add 3 new columns containing rates and the other one adds converted sales values in all 3 currencies.

currency_rate.knwf (44.6 KB)

[thunderbolt983]

That works so well, and it is easy to understand.

Thank you so much for this.