Transform using Gen AI

Description

The Transform using Gen AI activity allows users to define a custom data transformation using a natural language Prompt. Infoveave’s generative AI engine interprets this prompt, generates Python code, and applies the transformation to the tabular input.

This activity is powerful when:

• Custom business logic needs to be applied to datasets (e.g., filling missing values, formatting dates)
• Users want to automate repetitive data wrangling tasks without coding manually
• AI-assisted logic can infer transformation rules from examples or intent

Use case:
Suppose salary data has missing entries. You can write a prompt like “Fill missing salary values with the average of available salaries” — and Gen AI will compute the average and apply the transformation dynamically using generated Python.

Input

Field	Required	Description
Data	Yes	Structured input data with at least one row and column.

Output

Output Type	Format	Description
Data	Tabular	Transformed version of the input data as per prompt.

Configuration Fields

Field Name	Description
Prompt	Required. A user-defined instruction in natural language describing how to transform the data.
Code	(Auto-generated) Python code generated by the AI model based on the prompt. Can be reviewed.

---

Sample Input

SalesPerson	Name	Department	Salary	JoinDate
101	John Doe	HR	50000	2020-01-15
102	Jane Smith	IT		2019-03-10
103	Alice Johnson	Finance	60000	2021-06-25
104	Bob Williams	Marketing		2018-09-12
105	Emma Brown	Sales	65000	2022-02-20

---

Sample Configuration

Field	Value
Prompt	Fill missing salary values with the average of existing ones.
Code	(Auto-generated Python code to calculate average and replace)

---

Sample Output

EmployeeID	Name	Department	Salary	JoinDate
101	John Doe	HR	50000	2020-01-15
102	Jane Smith	IT	58333	2019-03-10
103	Alice Johnson	Finance	60000	2021-06-25
104	Bob Williams	Marketing	58333	2018-09-12
105	Emma Brown	Sales	65000	2022-02-20