Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
How to send a notification email to the assigned individuals for each issue in the issue list?"Hello All, I need send a notification email to the assigned individuals for each issue in the issue…
-
How to export dataset through API from Aperture Data studio?Hello All I want to export one dataset in Experian through API and save it as csv file in my one d…
-
3Add additional dataset source - dropzone namingHi, I really like the capability to have multiple dataset sources, I have used it numerous times - …
-
6Trash Bin?What problem are you facing? Deleting of batches often after a failed run. It's nerve racking…
-
4Sticky Notes attached to Workflow stepJust a thought… but it would be really nice if Sticky notes could be pinned to workflow steps (I al…
-
Automation - only writing to last batch to datasetHi, I have a multi-batch dataset (lets say DS1) that is configured for an external dropzone. When n…
-
2A way to "execute workflow with all batches in the Dataset" when a new batch triggers the executionWhat problem are you facing? A common setup in automated end-to-end automation in Data Studio is: …
-
ℹ How to track DQ issues with Issue listsIssue lists allow you to capture problematic records, assign them to stakeholders and collaborate o…
-
Pushdown Processing on a pivotHi, In testing Pushdown Processing today, I hit a couple of errors. The first is simple to workarou…
-
Power BI OData connections are significantly slowing down Aperture, how to configure to prevent?Hi, Our self-service users are using Odata connections to fetch data from Aperture DS to Power BI b…
-
External system drop zone stopped workingHi, The drop zones that I have set up for several subfolders for many files has stopped working, an…
-
Find Duplicates no connectingHi there, I am having problems making the duplicate stores connect to the server. I checked the ser…
-
Data Management User Group - 20 NovemberIt's time again for our popular Data Management User Group to get customers and users of Apert…
-
9Administration Space containing info on all objectsGeorge_Stephen - December 11 "Please create a Administration Space that contains information o…
-
Search and replace of multiple values.Hi everyone!, I have a table with 2 columns, the first one is the string I should check inside a f…
-
Suggested approaches for manipulating JSON valuesMy data includes a column containing JSON values - I've made a dummy example below: Example …
-
Create a function that compares the date open to todays datehow would i create a function that compares the date open to today's date
-
Find Duplicates IssueHi there, I'm having this issue with the find duplicates step, can anyone help?
-
Schema-Flexible Configuration with JDBC (Apache Hive 6.0) External SystemWe've successfully configured an external system using Connection type: JDBC and DBMS: Apache …
-
How can I configure TLS for the Find Duplicates WorkbenchWhat are the steps to configure an SSL certificate for the Find Dupes Workbench site? I already hav…
-
1Improved Driver support for Teradata data warehouse platform.What problem are you facing? Improved Driver support for Teradata data warehouse platform. We curr…
-
Useful Function: Distance between two coordinatesRecently developed a function based on the Haversine Formula to generate the distance between two c…
-
Workflow option to Refresh Sources doesn't apply to Contains MatchHi, I have a validation step that performs a 'Contains Match' on a lookup table (I am che…
-
Data Governance Masterclass - 9th OctoberHi all, We’re excited to invite you to our upcoming in-person Data Governance Masterclass on Thurs…
-
Date column recognized as "alphanumeric" while profilingi have some date columns in my table (like below example). Just done profiling on those columns it …
-
Distinct count aggregationI am not sure how to apply distinct count as aggregation while do group by ? There is check box &q…
-
♻ Reusable workflow example – calculate word frequencyToday I’d like to share with you a reusable workflow that I built a little while ago not only as a …
-
How to explore Workflow script (preview) functionalityRecently we upgraded to experian 3.1, and i would like to try Workflow Scripting (preview). But i u…
-
3Manually reviewing clusters of duplicate records (Stewardship)What problem are you facing? As a Find duplicates user I want to be able to manually evaluate and …
-
9Find Duplicates: handling of Gmail email modifiersWhat problem are you facing? The Email and Email_Local elements in Find Duplicates Standardization…
-
Word FrequencyEvery now and then a scenario crops up where it'd handy to know how often a given word occurs …
-
Address Elements, how does the Duplicate Store determine which element a field is?Hi all, Does anyone know where I can find some detailed documentation on how the duplicate store de…
-
Automation Email Trigger Works for Individuals, Not Distribution List(DL)Hi Aperture team, I’m currently using the Automation feature to trigger email notifications. Since …
-
4OAuth 2.0 authentication method with SnowflakeWhat problem are you facing? How can we connect to Snowflake external system with OAuth 2.0 authen…
-
connect to Snowflake external system with OAuth 2.0 authentication methodHello, How can we connect to Snowflake external system with OAuth 2.0 authentication method? Than…
-
Is there a way to generate Univeral Unique ID for each row?I want to create a new column that has Univeral Unique ID for each row. Is there a way in ADS to ge…
-
1Whatsapp Validation as replacement for Email validationWhat problem are you facing? An Indonesian based financial services company is looking to replace …
-
2Dataset API - External System DropZoneWhat problem are you facing? The dataset API only shows if the "server dropzone" is enab…
-
Dataset API - DropzoneHi, When using the dataset API, the value for "Enableddropzone" is FALSE even though the …
-
Re usable workflow, with different sourcei have created the workflow(Let say workflow_1 with source as dataset_1) and make it as reusable. c…
-
3Push down processing connection to Big QueryWhat problem are you facing? Comparing bank transactions at the bank is a major issue and time con…
-
1Synthethic Data - Asks from clientsWhat problem are you facing? Long project timelines replicating data from production and masking P…
-
Salesforce import failsHi, This is one of the error messages. In some cases there is no error message in the log file alth…
-
Bringing Data TogetherKnowing the best path for working with multiple datasets can be confusing sometimes, understanding …
-
Strengthening Data Quality with ABN ValidationHi DQ Community, I wanted to share some insights into the powerful custom workflow step for ABN (Au…
-
Email and Telephone numbers ValidationHi Everyone, We are currently reviewing the email and telephone validation functionalities within A…
-
How can I rename the values in a RAG column while keeping the colour styling using SetCellStyle?Hi everyone, I’ve created a RAG-style column in my Aperture workflow using SetCellStyle, and it’s …
-
v2 to v3do i need to do v 3.0.0 when i m going from ads v2 to v3, or i can go straigh tto latest ads v3.0.8…
-
2Ability to List Automations (eg. API)What problem are you facing? I need to ensure that automations have been created for specific task…
-
List Automations?Hi - is there a way to list all automations? (i.e via SWAGGER). I see there is a way to see schedul…
Categories
Popular tags
- Release notes 226
- Aperture Data Studio 166
- Functions 64
- Find Duplicates 59
- Datasets 47
- Workflows 46
- REST API 37
- Data Studio 33
- feature demos 26
- dmx 26
- JDBC 24
- tips and tricks 23
- Rules 19
- Automations 19
- validation 18
- Validate 17
- Transform 16
- Community Challenge 15
- Notifications 15
- v2.14 15
- datasource 15
- Downloads 14
- v2.12 14
- v2.8 14
- Extensions 14