Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
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 withi…
-
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 'Percentile'…
-
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 see what …
-
Gen AI in Aperture Data StudioAperture Data Studio has functionality that uses several different machine learning and artificial …
-
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…
-
Missing Tables in "Table or Database View" but Accessible via "Database QueryHi community, I successfully created an external system connection to a database schema, including …
-
Changing the External Source underlying the data setHi, We have developed several workflows using several data sets that are sourced from a particular …
-
Manual match cluster refinement - UpdateI'd like to share some progress we're making with Data Stewardship or as we're calling it, "Cl…
-
How to save profiling result as view for multiple table(50+ tables)I have many tables, i need to run profiling on each of the tables and need to save the results as v…
-
How to resolve "No space left on device" errorsHello, In the last few days we have been encountering the "An unexpected error has occurred d…
-
1View batch data as an action item under 'Show Batches'What problem are you facing? When I take the option 'Show batches' for a dataset, I see the list o…
-
STS account - Reactivationhi @Ian Hayden , Sent you an email regarding reactivation of STS acc. we have tried to contact ser…
-
How to Cancel an Ongoing Dataset Refresh?Hi, We successfully triggered a data refresh on our dataset. However, we now need to stop or cancel…
-
Drop Zone Configuration - Occasionally dropped files are not picked upHowdy, I have been dealing with a slight issue with a server drop zone setup we use for a specific…
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
- feature demos 26
- dmx 26
- tips and tricks 21
- JDBC 20
- Rules 19
- Automations 19
- validation 17
- Validate 16
- datasource 15
- Transform 15
- Community Challenge 15
- v2.14 15
- Notifications 15
- Extensions 14
- v2.12 14
- Downloads 14
- v2.8 14