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
-
Go to the Transform menu and select the Formula column option.
-
In the New column name field, enter the desired name for your new column.
-
In the Formula field, enter
""(two double quotes) to create a new column with empty values. -
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.
2. Enter the prompt in natural language in the command prompt section.
Prompt: 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.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Export data to Zoho Analytics
You can export the refined data to data analytics tools such as Zoho Analytics. To export data to Zoho Analytics 1. Open an existing pipeline or create a pipeline from the Home Page, Pipelines tab or Workspaces tab. You can bring your data from ...Export data to Zoho Creator
Zoho DataPrep supports exporting data to Zoho Creator using the Zoho Creator connector. Zoho Creator is a powerful low-code application development platform that helps businesses build custom web and mobile apps faster. To export data to Zoho Creator ...Import data from Snowflake
Zoho DataPrep supports importing data from Snowflake, a cloud database. Snowflake is a cloud data warehouse that can store, process and analyze data. Important: Starting from October 2024, all new Snowflake accounts will have multi-factor ...Importing data from Zoho Analytics
DataPrep supports importing data from Zoho Analytics. Zoho Analytics is a self-service BI and data analytics software that lets you visually analyze your data, create stunning data visualizations and discover hidden insights from your data. With this ...Import data from Zoho CRM
Zoho DataPrep allows you to seamlessly bring in your sales data from Zoho CRM using the Zoho CRM connector. Using the connector, you can import your sales data from CRM to perform ETL operations like data cleanup, data migration, data sync, and data ...