topic Re: Currency Conversion in Talend Studio

Currency Conversion

shalinim1 — Sat, 16 Nov 2024 01:14:48 GMT

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 — Tue, 27 Oct 2020 10:33:28 GMT

Hi @Shalini M ,

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

shalinim1 — Tue, 27 Oct 2020 12:55:05 GMT

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