Zoho DataPrep solution guide
How to export modified data to the cloud database?
This guide will help you sync data from a source application or database to a cloud data warehouse, transferring only the new and modified records from the source system to the destination data warehouse. Let's assume you want to sync data from an ...
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: Go to the Transform menu and select the ...
How to truncate and add data from other sources to Zoho CRM and Creator?
When working with dynamic source data, such as data from Zoho Analytics to Zoho CRM or Creator, you may need to completely remove existing records in a CRM module or Creator forms before inserting the latest data. Since Zoho CRM and Zoho Creator do ...
How to normalize E-notations or exponential values?
Case 1: When your dataset contains a column with exponential values Let's take a dataset with negative and positive exponential notation in a column. These exponential values must be converted to their decimal equivalent. To achieve this please try ...