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.
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
i have created the workflow(Let say workflow_1 with source as dataset_1) and make it as reusable. created another workflow(Let say wrokflow_2 as parent workflow) with workflow_1 as child workflow and changed the source as dataset_2. dataset_1 & dataset_2 are exactly same, the only difference is that the dataset_1 has one…
Join us for our upcoming Data Management User Group! Get exclusive insights into the latest plans, hear how leading organisations are tackling real world data challenges, join expert-led discussions on today’s most pressing data issues. We look forward to seeing you there.
