Replace a Column
You can view the following fields when you select Add or Replace from Column Action.
- Enter a prompt in natural language or specify SQL for column: Select any one of the prompts suggested by the tool.
- Click Ask AI.
The Ask AI button to send the prompt with table metadata and asks the Large Language Model (LLM) to generate a SQL.
- Click Replace Column.
Select a column you want to replace from the Column Name to Replace drop-down field.
The SQL textbox displays the equivalent SQL code the tool generates to display the action performed by the column action you selected in the previous step.
- Under Data Preview, you can view the existing old column and the updated new column.
- Save the newly created recipe.
By default, the Table AI Assist tool does not replace the original source table. It only affects the new view or table that is generated by the Table AI Assist tool.
After you have decided the column action, click Add Step to add this step in the main recipe panel.
Clicking Add Step closes the Add Step dialog and opens the Table AI assist page.
Parent topic: Prepare Data Using Table AI Assist Tool