AI Table
Creates a new table based on GPT prompt
Overview
By adding AI Table Node, you can execute complex transformations over single or multiple tables with just a natural language prompt. It is a revolutionary productivity tool designed to simplify the creation of complex data transformations - it allows you to condense multiple transformation steps into a single node.
Settings
Input nodes
Select the nodes you want to work with. The "+Add node" link allows you to add multiple nodes and select a node on the canvas.
Assign them custom names to make it simpler to refer to when constructing the prompt.
Prompt
Write your prompt in natural language to describe transformations you want to do over input datasets. You could mention the existing columns using @ symbol.
AI doesn't know the data in the columns. It only knows the schemas of the selected nodes (column names and types) and one row of data. That means you cannot ask it to calculate results based on knowledge about values in the table. But you can ask anything if it can be done using standard functions.
AI returns a completely new table based on your request.
If AI returns incorrect results, try rewriting the prompt using more details. For example, you could specify the names of columns as context. You can also try different approaches to making a prompt to achieve the desired result.
What to ask
Any manipulation with input datasets such as join, group, summarize, filter, sort
Find the top 5 most active users by the number of events
Filter users with empty names
Return user numbers by country codes, filter top 10
Group users by industry
As AI knows nothing about the data in the tables, it cannot answer the questions like:
Find negative reviews
Filter users with inactive status (for example, if the status can be “on hold”, “inactive”, “or removed” - all inactive - AI doesn't know that you need specifically mention all these statuses)
Find all users from NY (again, AI doesn't know the data in the city column and doesn't understand how to create a filter: “NY,” “New York,” “Apple City”)
Last updated
