Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Suggested approaches for manipulating JSON valuesMy data includes a column containing JSON values - I've made a dummy example below: https://u…
-
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 …
-
5A default value for "automatically delete data after N days"What problem are you facing? Almost all the data loaded into my Data Studio instance has a mandate…
-
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 …
-
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 …
-
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…
-
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…
-
Find Duplicates - Ignore a valueHi, I am attempting to use the find duplicates module. In one of my unique data fields I have dfo…
-
Best approach- to do profiling for large dataset (20 million records)Hello , I need to do profiling for tables which have more than 20million records and also the tabl…
-
Cloud licensingHi team, We have deployed ADS production server and when we tried to apply the cloud license, we ar…
-
QAS Vs Experian Aperture Address ValidationHi, We currently use QAS for address validation and currently running POC for Aperture data Studio.…
-
How can I create a custom RAG (Red-Amber-Green) status column in my Aperture workflow?Hello! I’ve been using the built-in validation rules in Aperture (like validate telephone, email, …
-
I just got a 3+ sign-ins in a month badge or a frequent flyer badge.I see dont see any info about this or any other badges, or way to earn points.
-
1Option to include Group Name in Validate All ResultWhat problem are you facing? Validate Step All Results - Duplicate Rule names used in different gr…
-
Validate Datetime Datatypei want to validate that the column datatype is "Datetime" Datatype. i found only "Is…
-
6To be able to use groups and group permissions when using SAML and LDAPWhat problem are you facing? Administrators are currently having to add individual users. This is …
-
Percentile calculationHi everyone, I created a reusable workflow that define wheter a column value is in the 'Percen…
-
11Combine Filter/Split stepHi, I'm raising this on here as it's come up a few times with various users and I want to…
-
Moved: Gen AI in Aperture Data StudioThis discussion has been moved.
-
New Database DriversAre there any database drivers that people would like us to have access to? Please cast your vote …
-
Workflow failureHi everyone, I am getting this error on one of my workflows. Can anyone help?
-
Ankita Singh: Senior DQ Delivery ConsultantI am a Senior Consultant at Experian Data Quality and is mainly responsible to support our ANZ clie…
Categories
Popular tags
- Release notes 206
- Aperture Data Studio 162
- Functions 64
- Find Duplicates 59
- Workflows 45
- Datasets 44
- REST API 36
- Data Studio 33
- dmx 26
- feature demos 26
- tips and tricks 22
- JDBC 21
- Rules 19
- Automations 19
- validation 17
- Validate 16
- v2.14 15
- datasource 15
- Notifications 15
- Community Challenge 15
- Transform 15
- v2.8 14
- Extensions 14
- v2.12 14
- Downloads 14