Convert currency

Description

The Convert Currency activity transforms amount values from one currency to another using up-to-date exchange rates. Input values must follow the ISO 4217 format (e.g., 100.00 USD). You can convert to a target currency and store the result in a separate column.

Use this activity to:

• Normalize all transaction values to a single currency (e.g., INR, USD).
• Prepare financial reports by standardizing currency across global datasets.
• Retain or discard original columns based on your analysis needs.

Use case: Convert international salaries (in USD, EUR, GBP, etc.) to INR before budgeting or taxation processing.

Input

Input Type	Required	Description
Data	Required	Input data must contain at least one column with values in amount + currency code format (e.g., 12000.00 USD).

Output

Output Type	Format	Description
Data	JSON	Transformed data with converted currency values

Configuration Fields

Field Name	Description
Column Name	Select the column containing values like 12000.00 USD.
Output Column	Name of the column where the converted values will be stored.
Convert To	The ISO currency code to convert all values into (e.g., INR, USD, etc.).
Include Original	If true, retains all original columns. If false, only includes the converted output.

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

Sample Configuration

Field	Value
Column Name	amount_in_iso
Output Column	INR
Convert To	INR
Include Original	true

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