Build Your Own Function (BYOF)
The BYOF (Build Your Own Function) node allows you to create custom row-level functions tailored to your specific requirements. This feature is highly adaptable, supporting operations across various data types, including numerical, textual, and date-based data.
With AI-assisted formula generation, the BYOF node simplifies complex function creation, offering both manual and automated methods to design and validate row-level operations.
Supports operations on numerical, textual, and date-based data types.
Provides AI-assisted formula generation to simplify complex formula creation.
Allows users to manually modify or refine generated formulas.
Includes functionality to preview and validate results before applying functions to datasets.
Node Configuration
When configuring the BYOF node, users can follow these steps to build and apply their custom row functions effectively:
1. Select the Column for Row Function
The first step is to select the column on which the custom function will be applied:
A list of available columns is displayed.
Search Functionality: Use the search bar to quickly locate the required column.
Selection: Click on the desired column to select it. Once selected, the column is prepared for further configuration.
2. Define the Function Description or Formula
This section enables users to describe the function they wish to create, either manually or with the assistance of AI.
Input Options:
Manually Input Formula: Enter the desired formula directly in the input field.
AI-Assisted Formula Generation: Provide a brief description or a prompt and click Generate to use AI assistance for formula creation.
Steps to Use AI Assistance:
Enter a description of the operation (e.g., "Calculate 10% of Sales").
Click the Generate button to trigger AI-assisted formula generation.
3. Review and Edit the Generated Expression
After providing a description or manually inputting a formula, the system generates an expression in a separate field:
Generated Expression Field:
Editable Expression: The generated formula is displayed and remains fully editable. Users can make changes to better suit their requirements.
Re-Initiate Formula Generation: If the generated result does not meet expectations, click Re-Initiate to rerun the AI process and produce a new formula.
4. Preview Results
Before finalizing the configuration, validate the output of your custom row function by previewing the results:
Click on Preview Results to see the effect of the formula on the selected column.
This preview helps verify that the function produces the intended output.
Example Scenario
Problem Statement: Calculate the total amount for each transaction by applying the tax rate to the sales amount. This will give you the final amount after tax for each transaction in the dataset.
Transaction ID | Region | Sales Amount | Tax Rate | Transaction Date |
|---|---|---|---|---|
1001 | North | 500 | 0.08 | 2024-01-01 |
1002 | South | 700 | 0.05 | 2024-01-02 |
1003 | East | 1200 | 0.07 | 2024-01-03 |
1004 | West | 800 | 0.06 | 2024-01-04 |
1005 | Central | 1500 | 0.09 | 2024-01-05 |
Steps to Configure:
Select the Column for Row Function:
Choose the
Sales AmountandTax Ratecolumns from the list of available columns.
Define the Function Description or Formula:
Provide the description: "Calculate the total amount by adding tax to the Sales Amount."
Use AI-Assisted Formula Generation or manually input the formula:
Sales Amount + (Sales Amount * Tax Rate)
Review and Edit the Generated Expression:
Verify that the generated expression is
Sales Amount + (Sales Amount * Tax Rate).Edit if required.
Preview Results:
Click on Preview Results to validate the total amounts for each row.
Transaction ID | Region | Sales Amount | Tax Rate | Total Amount |
|---|---|---|---|---|
1001 | North | 500 | 0.08 | 540 |
1002 | South | 700 | 0.05 | 735 |
1003 | East | 1200 | 0.07 | 1284 |
1004 | West | 800 | 0.06 | 848 |
1005 | Central | 1500 | 0.09 | 1635 |