Bulk change columns data type
Hello, is there a way to bulk change the columns data type in a Dataset? Thank you
Zoho DataPrep integration with OpenAI (beta)
We are thrilled to announce Zoho DataPrep's integration with OpenAI. The public beta roll-out opens up three features. Users who configure their OpenAI Organizational ID and ChatGPT API key (Find out how) will be able access the features. The features
Problem with getting Zoho Recruit Notes
Hi, I am trying to access all notes in ZohoRecruit (because Zoho Analytics does not offer them as a table) https://www.zoho.com/recruit/developer-guide/apiv2/get-notes.html https://www.zoho.com/recruit/developer-guide/apiv2/access-refresh.html https://www.zoho.com/recruit/developer-guide/apiv2/whats-new.html
Data Prep Previous Rulesets not Showing
I applied preparations to a dataset but when I wanted to modify those preparations they no longer appear in the ruleset or ruleset history, meaning I need to redo everything from scratch and re-prepare my data. Any idea why this is happening? It's becoming
Deduplication
Hello, Is there a way to identify a duplicate row entry across multiple Text columns? For example, a duplicate row is if "Region" and "Product Area" and "Product" are all the same entries. I cant seem to get it to work in the Advanced section of the Transformation
Zoho CRM connector's export functionality enables end-to-end CRM data pipeline
We're thrilled to announce an update to our Zoho CRM connector that will enable you to create data pipelines to Zoho CRM. The public beta of "export to Zoho CRM" is now available, and can be enabled for users requesting it via email. Using the feature,
Ability to specify the time when scheduling import and export or trigger export after import completes
Right now, I have to actually creates the schedule at the exact time I want to run which is silly!
How to split an email address in data prep
I am trying to match my emails address to the accounts using domains. I am importing my contacts into data prep and would like to spilt the email address at the "@" symbol so I have the domain name, any help on how to do this and import this value back
URL import and APIs with pages/offset/limits
While the URL import allows to include parameters, how can we iterate through the page numbers or offset/limit until all data is imported?
De-Duplication
Hi, Within the CRM you have the ability to De-Duplicate Contacts based on email, is there a way to do this on Dataprep?
Retain column names when importing through URL
In Zoho Analytics there is an option called Retain Column names when importing through URL. Without this, the column names are preceded with the JSON records (i.e. records.id, records.abc, etc.). I know I can rename the columns, but having to rename
Export / Import Issue - ZOHO_DDL_OPERATIONS is more than required length
Alert Message Data preparation failed. Reason: The length of the parameter ZOHO_DDL_OPERATIONS is more than required length Am I trying to transform to much data?
Automation with Dataprep
Hi, this looks like a very exciting app, but i need to make sure that it works for our requirements. Is there any way Dataprep or another Zoho service can monitor a WorkDrive folder to start a transformation if a new file is added and then move the file
Count more than 24 hours
Hi, I am trying to prepare my user logs for dashboarding. However I have found that the columns with usage time do not exceed the 24 hours. Is there a way to let it count longer timeperiods? Thanks in advance. Dave
Zoho Dataprep part of Zoho ONE
Hello, is Zoho Dataprep part of Zoho One? Thank you, Oliver
Zoho DataPrep is now launched!
We are excited to announce the launch of Zoho DataPrep – An advanced self-service data preparation and data pipeline service. Introducing Zoho DataPrep Zoho DataPrep helps organizations prepare data by automatically identifying errors, discovering data
Export data from Dataprep to zoho analytics
Hi, I am trying to export a prepared data from DataPrep to Zoho Analytics, but it won't export and throwing an "unexpected error" error message. My question is do I have to have a table in zoho analytics with the same structure(columns) before export