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 Select for the specific job.

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 function 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 (yyyy/mm/dd → 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

Single Column Function

Example: Multiple Columns Function

Convert currency from rupees to dollars.

1. Select Multiple Columns mode.

2. Define transformation logic:

   • Convert transactionamount and accountbalance from INR to USD where currencycode = 'INR', round the converted amounts to 2 decimal places, and update currencycode to USD.

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

Multiple Columns Function

Step 5: View 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