Failed job notifications
Is there are way to receive an alert when a job has failed? If not this would be a useful feature.
Specify query with parameters
Hi, Is it possible to specify a sql query with filter parameters? Alternatively, is it possible to specify filters for a sql db table being imported? Thanks, Nick
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?
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
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
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?
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