Skip to content
Infoveave Help

Split Currencies

Description

This activity splits the specified column containing amount and currency into two different columns, one with the amount and the other with its currency.

Input

Data only

Output

Transformed Data

Configuration Fields

  1. Column Name Allows single select, must contain amount with currency.
  2. Include Original
    • Enabled Includes the input data along with transformed column .
    • Disabled Gives only the transformed column .

Sample Input

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

Sample Configuration

alt text

Sample Output

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