How to add a new blank column and update its values in the imported data?

How to add a new blank column and update its values in the imported data?

Case: Adding a new blank column and updating its values in Zoho DataPrep

a) Using Formula transform

You can add a new blank column to your data and update records in that column using the following steps:

  1. Go to the Transform menu and select the Formula column option.

  2. In the New column name field, enter the desired name for your new column.

  3. In the Formula field, enter "" (two double quotes) to create a new column with empty values.



  4. Once the column is added, you can use the Fill empty cells transform to update the empty cells with the required values.



b) Using Ask Zia transform

You can also use Ask Zia to add a new column and fill values in it with a simple prompt.

Case: I want to create a new column and fill values based on the existing data.

1. Click the Ask Zia icon from the top right corner of the Studio page.
2. Enter the prompt in natural language in the command prompt section.
For example, if you would like to add a column that marks orders as High priority when the order amount is above 5000, and Normal otherwise, you can use the following prompt:

QuotePrompt: Create a new column called Priority and fill it with High if Order Amount is greater than 5000, else Normal.

3. Click Enter or  icon and you will see a preview of the data generated by ChatGPT.

The preview will show the new column created with the values filled based on your input.



4. Click Apply Transform to apply the transform to the entire data.