The place for most Aperture Data Studio discussion
The Data Quality Community is a great place to collaborate, seek answers, and learn Aperture Data Studio. Register for free to join in with discussions.
I'd like to share some progress we're making with Data Stewardship or as we're calling it, "Cluster refinement" for data matching within Aperture Data Studio. We've been told by a few of you that it would be a very useful capability. The original post on the community ideas board can be read here. The improvements we're…
For our customers on the Aperture Data Studio Hosted and Managed Service: The maintenance schedule is now available on the Community site at this section. There is also an option to subscribe to maintenance status updates at the Experian Data Quality status page.
Hi, The drop zones that I have set up for several subfolders for many files has stopped working, and even after a restart continues to not work. The log contains a lot (a lot!) of these messages: INFO c.e.d.d.ExternalDirectoryWatcher [ExternalDirectoryWatcher-e3649cf8-de9f-42e2-8eec-edee6e98c157 1369857878] Error fetching…
Hi everyone!, I have a table with 2 columns, the first one is the string I should check inside a field, the other column is the value I should replace if its a match. How can I achieve this without creating a function with lots of steps for each string I need to search and replace. ORIGINAL STRING NEW STRINGTEXTO NUEVO -|…
how would i create a function that compares the date open to today's date
Hi there, I'm having this issue with the find duplicates step, can anyone help?
We've successfully configured an external system using Connection type: JDBC and DBMS: Apache Hive 6.0. I’m looking for guidance on how to set up a Schema-Flexible configuration. Specifically: Is it possible to use Schema-Flexible JDBC connections to support workflows that export data to multiple schemas? For example,…
Hi, I have a validation step that performs a 'Contains Match' on a lookup table (I am checking FK integrity). The workflow is set to 'Refresh Sources' however this does not apply to the lookup table. (I noticed due to failed rows). What is the recommended best practice here? Thanks
i have some date columns in my table (like below example). Just done profiling on those columns it recognizes their datatype as alphanumeric instead of date. after profiling i just right click and seen the values, there it shows as Date datatype all rows have date only in MM/DD/YY format because of this i am getting wrong…
I am not sure how to apply distinct count as aggregation while do group by ? There is check box "distinct", even though i enable that still does not give distinct count. Can someone help me to apply distinct count as aggregation in group by
Recently we upgraded to experian 3.1, and i would like to try Workflow Scripting (preview). But i unable to find those feature. Can anyone please help me with this?
Hi, When using the dataset API, the value for "Enableddropzone" is FALSE even though the dataset is set up for "Enable external system dropzone". Does the API only show "Enable server dropzone"? Thanks