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
Integration With Creator
Is integration with Zoho Creator possible? If not presently, is it on the roadmap?
Relative Dates
Is there a way to apply a Relative Date filter in DataPrep (ie. Today or Yesterday)? I need to filter a dataset to only include rows with a created date of yesterday, but I’m not finding a way to do it?
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?
Export to zoho CRM
It's so pity .Dataprep can't export to Zoho CRM via connection. If Dataprep can do that .It will save a lots of time to integrate.
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
Currency data type invalidates any value above 999.99
I imported sales data from Amazon via an XLSX file. The data type in Excel was "Currency". Data prep is showing any value of $1000 or over as invalid. I tried deleting the $ and any commas, removed whitespaces and still any value above that amount comes
What is Zoho DataPrep? | Self Service Data Preparation
The productivity provider SaaS provided Zoho entered the business intelligence platform field in July 2021. Zoho announced an AI-powered data preparation, business intelligence, and self-service platform application that combined the new Zoho DataPrep
dataprep connection with databridge
Hi i have tried con connet using you r data bridge before an database on analitycs and today im'trineg to confirgure anoter conenction trouht datbridge application . bu unfortunately i cant connect to anyting. i don't revice any errors or any infiormationa
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
Launch Blueprint or Workflow Automation via Zoho Dataprep Import
Greetings All, I'm curious - Is it possible to trigger a Blueprint or Workflow via Data Prep import? Thanks in Advance
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