Convert Currency

Description

This activity converts the values of the specified columns containing amount in ISO with currency code into the required currency.

Input

Data only

Output

Transformed Data

---

Configuration Fields

1. Column Name Allows single select, must contain amount with currency.
2. Output Column Name of the output column to store the transformed values.
3. Convert To The specific currency to which the values need to be converted.
4. Include Original
   • true Includes the data columns from the original data.
   • false Only the transformed column and the output column are included.

---

Sample Input

employee_id	name	amount_in_iso
E001	John Doe	20000.00 USD
E002	Marie Dupont	35000.00 EUR
E003	Carlos Gómez	30000.00 GBP
E004	Ravi Patel	120000.00 INR
E005	Sophie Müller	50000.00 JPY

Example Configutration

Sample Output

employee_id	name	amount_in_iso	INR
E001	John Doe	20000.00 USD	1727369.00 INR
E002	Marie Dupont	35000.00 EUR	3167388.86 INR
E003	Carlos Gómez	30000.00 GBP	3226744.82 INR
E004	Ravi Patel	120000.00 INR	120000.00 INR
E005	Sophie Müller	50000.00 JPY	27718.43 INR