Skip to content
Infoveave Help

Split currencies

Description

The Split Currencies activity processes columns that contain combined monetary values (e.g., "75000 USD", "85000 ₹") and separates them into two distinct columns: one for the numeric amount and one for the currency symbol or code.

This transformation is essential when analyzing or converting financial values, enabling downstream processes like currency conversion, aggregation, or filtering by currency type.

Use case:
HR datasets containing salary fields such as "75000 USD" or "72000 Rs" can be normalized into separate Amount and Currency columns for reporting or standardization.

Input

TypeDescription
DataA dataset with at least one column containing combined numeric and currency text.

Output

TypeDescription
DataTransformed dataset with extracted amount and currency in separate columns.

Configuration Fields

Field NameDescription
Column NameSelect the column that contains combined amount and currency values (e.g., "85000 USD").
Include OriginalDetermines whether the original column is retained in the output.
  • Enabled – Keeps the original column.
  • Disabled – Only returns the new amount and currency columns.

Sample Input

employee_idnamesalary
E001John Doe75000 USD
E002Jane Smith85000 $
E003Ali Khan90000 AED
E004Maria Gonzalez68000 USD
E005Rahul Sharma72000 Rs

Sample Configuration

FieldValue
Column Namesalary
Include OriginalEnabled

Sample Output

employee_idnamesalarysalary_Amountsalary_Currency
E001John Doe75000 USD75000USD
E002Jane Smith85000 $85000$
E003Ali Khan90000 AED90000AED
E004Maria Gonzalez68000 USD68000USD
E005Rahul Sharma72000 Rs72000Rs

The transformed data clearly separates monetary values, enabling easier processing, filtering, and reporting based on currency or amount.