Currency Conversion

[shalinim1]

Hi,

I have a lookup currency table which has columns as currency_from, currency_to, and currency_rate. And the main table has the currency_type column.

I have mapped the main table

 currency_type and lookup table's currency_from in tmap component.

I want conversions for different type of currencies like USD,EUR,GBR and so on.

How to get different currency_to and respective currency_rate from a single lookup table?

[vikramk]

Hi @Shalini M​ ,

You could perform join conditions if you have key columns in both the tables.

[shalinim1]

@Vikram Kumar​ I have currency types as rows. So if I map them, I cant get every currency conversion to be done.