Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
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…
-
5Add record limit to source stepWhat problem are you facing? Working with very large datasets, sometimes hundreds of millions of r…
-
Route to live process & environmentsHi, I want to get a route to live process in place whereby only things which have been peer reviewe…
-
Data Governance Masterclass 10th JulyHi all, We’re excited to invite you to our upcoming in-person Data Governance Masterclass on Thursd…
-
OData $top in Power BIHi, We are trying to pull a dataset into Power BI and limit to 1000 rows whilst we iterate to make …
-
Address Validation IssueHey community, I have just updated to the new version of ADS, also updated the address validation, …
-
Guidance Needed: Transitioning Data Sources from HD Insights to DatabricksHi Team, We are anticipating changes in our datastore architecture, which will significantly impact…
-
OpenText Content server exportHi All, I’d like to ask whether Aperture is capable of directly connecting to OpenText Content Serv…
-
6Group Step Sum of Nulls should return NullWhat problem are you facing? When getting the Sum of a column via a Group Step, if all the values …
-
7Determine the minimum numeric value when column contains null/string valuesWhat problem are you facing? The "minimum" aggregate returns null() as the minimum if at…
-
5Auto discovery of keys (foreign, primary)Logging this idea on behalf of @AlanB (feel free to add further commentary) What problem are you fa…
-
How to modify in aperture the header for Powercurve Collections interfacesI am working on the input interfaces that PCC manages, which has the following nomenclature Proces…
-
Fire event - if input has no rowsHi All, I would like to fire an event (run a specific workflow) if NO rows in the input - but there…
-
What is the cause of an error message that says "4058: Unable to rollback" and how can it be fixed?This error occurs on the Export workflow step.
-
Column header in the second rowHi All, is there a way to use the second row (instead of the first) as the column names when upload…
-
Is there an easy way to do this partitioning?Hi, I have seen previous posts on partitioning, and use that technique regularly. However, my need …
-
fill down or propagate values to empty cellsGood morning, what's the best way to fill down or propagate values for fields like 'Year' and 'Sub…
-
api key expiry notificationhi, can someone tell me simple steps to create alert on my api key, so that before it expires, i ge…
-
Your API key < API key name > will expire in 10 days'can u help me set up this? i cannot find the right directives in below documentation. i need to k…
-
Tagging as sensitive informationHi All, As I'm reviewing the space settings, I noticed there is a section called "Potentially …
-
Export views, datasets, schedules etc.Dear All! Is there an easier way to extract all the views, datasets, schedules etc. information fro…
-
Our Data Management User Group is on 20 May 2025Once again we would love you to join us for our next Data Management User Group taking place on 20 …
-
Sorting is better to do before Join?Does sorting of the participating ids in the joining condition helps in better performance? i thoug…
-
space issue in data folder.we have space issue on our indexes, I believe in last 2 days, that has grown more than 600GB, how c…
-
character encoding mismatchesHi, I'm having an issue when downloading a dataset in CSV format, some of the characters are been i…
Categories
Popular tags
- Release notes 198
- Aperture Data Studio 161
- Functions 63
- Find Duplicates 59
- Datasets 43
- Workflows 42
- REST API 35
- Data Studio 33
- dmx 26
- feature demos 26
- tips and tricks 21
- Rules 19
- JDBC 18
- Automations 17
- datasource 15
- v2.14 15
- Transform 15
- Community Challenge 15
- validation 15
- v2.8 14
- Extensions 14
- v2.12 14
- Validate 14
- Downloads 14
- v2.11 13