Creating Functions

Create reusable transformation functions for your jobs.

Important: Save the job before creating functions.

Step 1: Select a Job

• Identify the relevant job from the list.

• Click on the job name

Select Job

Step 2: Fetch Data

• Click Fetch Data to retrieve records from the selected source.

• Fetched data displays in a table for analysis.

Fetch Data

Step 3: View Fetched Data

• Review the data in tabular format.

• Use Add Row or Clear Data options as needed.

View Fetched Data

Step 4: Generate a Function

• Enter the prompt to generate transformation fucntion in the text editor.

• Choose Single Column or Multiple Columns mode.

• Provide a Function Name.

• Click Generate to create the function.

Example: Single Column Function

Convert date format from US to India format (mm/dd/yyyy → dd/mm/yyyy):

1. Select Single Column mode.

2. Choose the column (transactiondate).

3. Enter function name (e.g., Date Conversion).

4. Click Generate, then Run.

5. Review the transformed data in the table.

6. Verify the changes are correct.

7. Edit and re-run if corrections are needed.

8. Click Save to store the function.

Single Column Function

Example: Multiple Columns Function

Convert currency from USD to INR and adjust amounts:

1. Select Multiple Columns mode.

2. Define transformation logic:

   • Convert currency code from USD to INR.

   • Multiply transactionamount and accountbalance by 88.

   • Round to two decimal places.

3. Enter function name (e.g., Currency Conversion).

4. Click Generate, then Run.

5. Review the transformed data.

6. Verify the changes are correct.

7. Edit and re-run if corrections are needed.

8. Click Save to store the function.

Multiple Columns Function

Step 5: Access Saved Functions

• Navigate to Saved Functions from the left menu.

• View all created functions with details:

  • Function Name.

  • Function Type (Single or Multiple Columns).

  • Created By.

  • Created At.

Saved Functions