Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
New Experian Data Quality RoadmapI am delighted to announce that the interactive version of Experian Data Quality's product roadmap …
-
New Experian Data Quality RoadmapI am delighted to announce that the interactive version of Experian Data Quality's product roadmap …
-
The chaining effectWhat is the chaining effect? Find Duplicates in Aperture Data Studio works by identifying blocks or…
-
REST API: get dataset list and their informationHello, We are looking to identify all datasets (of all spaces) that are in autorefresh. When we use…
-
Does Aperture have "rank()" function and how it works?Hi, is there similar function for Aperture? For example case
-
Manual review of Find duplicates clustersUsing a similar approach to that covered in an earlier post we demonstrate a method for manually re…
-
Reviewing Find Duplicates ResultsWhen you preview the Find Duplicates results, you will see the Cluster ID and Match status. Record…
-
Snapshot build taking nearly an hourHi - I have a table of approx 25m rows looking up to 2 other tables to retrieve 2 values. I then ha…
-
Smart Harmonization FAQAs of release 2.4.5, you are able to turn on a preview of a new feature that involves smart models …
-
Encryption-at-rest FAQSince release 2.4.5, you can turn on a new security setting at Settings>Security, Encryption to …
-
Tuning Blocking KeysReview Find Duplicates step results Reviewing the Find Duplicates results may not be the best way t…
-
Find duplicates functionality, duplicate matching and duplicate record resolution.Hi community members We're looking for customers and external evaluators of Aperture Data Studio th…
-
Dynamic Naming of Output FileHi, Is it possible to have a dynamic text element of the naming of an output file. I understand th…
-
Error with resuable workflow step in new workflowHi, I have created a workflow that produces an output and has been made reuseable. This workflow i…
-
ODBC: connection failledHello, We are facing some issues when we try to apply ODBC procedure (https://docs.experianapertur…
-
Dynamic DataSet NamingHi, We are trying to use Aperture V2 as part of the ETL workflow. We need to pick the data set from…
-
Does Aperture has the feature of Fuzzy Matching on Name/Company Name?We do have company names but it is maintained in different system in a different way. in One system…
-
Document Data Lineage in my Aperture installationI have recently joined a company using Aperture to manage their data quality. They have set up seve…
-
Building RulesIn order to start testing the Find Duplicates step, the Find Duplicates settings will also need to …
-
Profiling many datasets of different schemasTo profile thousands of datasets easily, you can create a reusable workflow with a replaceable sour…
-
Error when running workflowWhen running a workflow I get the error message - One or more workflow steps are invalid - but no i…
-
Exact match and fuzzy match with Find Duplicates StepAperture Data Studio offers a Find Duplicates step that runs on a powerful standardization and matc…
-
Aperture Data Studio Hosted and Managed Service Maintenance ScheduleFor our customers on the Aperture Data Studio Hosted and Managed Service: The maintenance schedule …
-
Fuzzy Match with Regular ExpressionsImagine you have an address field containing variation of city names, for example: You need to dete…
-
Gauge Chart and Scoreboard chart with up/down tickGauge Chart A new chart type named Gauge chart has been added to the Chart step. The Gauge chart i…
-
🎞 Creating roles and assigning permissionsData Studio gives you some very fine grain control over what a given user can do within the system.…
-
🎞 Creating environmentsYou may have noticed that some users have more than one environment in their Data Studio Installati…
-
Selecting Best Record with Harmonize DuplicatesThere are times when you just want a quick way to deduplicate your data without necessarily knowing…
-
Exact Match with List functionsThere are a number of List functions that may be useful when you are trying to de-duplicate a list …
-
Exact Match with the Group StepThe Group step can be used as an easy way to identify and de-duplicate data that matches exactly. L…
-
How to Capture Trend of the DQ ScoresI have rules created and I have scheduled the rules to run on every weekend. Now how can I capture …
-
Why worry about duplicated data?What is duplicated data? Duplicated data refers to data representing the same entity. An entity can…
-
Length of the maximum number of columns?I'm trying to import database table data into Aperture, but I'm having a problem with the length of…
-
Importing and Exporting WorkflowsOne of the very first things that you will probably wonder, is just how portable are my workflows t…
-
Exact match, fuzzy match and de-duplication with Find DuplicatesHi everyone, I'm starting a series of articles all about matching and linking records to find dupli…
-
Quick introduction to Blocking Keys and Rules for Find DuplicatesThe concept of Blocking Keys and Rules may be foreign to you if you haven’t already used the Find D…
-
👋 Introduction to the Functions Library 📂Intro This area of the Community hosts our library of re-usable functions for use in Aperture Data …
-
-
🎞 A Short Feature Demo on data validation in Data Studiohttps://bcove.video/3hw8COt
-
-
🎞 A Short Feature Demo on dynamic workflows in Data Studiohttps://bcove.video/3ygaHTL
-
🎞 A Short Feature Demo on data views in Data Studiohttps://bcove.video/3hqh0Nt
-
-
-
Make your own reusable RIGHT function to return a number of characters from the end of a text stringA customer was asking if there is a way to achieve something similar to the RIGHT() function within…
-
Do we need license for the Data ConsumerWe have many Business users and want to give them only read access to the reports so we just want t…
-
How to get distinct value from a columnex I have company value in a table with contact details one company has multiple contact and now I …
-
Data dropzone - additional columnsHi! I'm involved in a piece of work at the moment where we're using Aperture to map data in prepara…
-
Join after a filterHello, In Aperture 2.2.6.118 , when we use a join function just after a filter , we get error messa…
-
ℹ️ Removing Exact Duplicates / Exact MatchesA common thing users want to do with Data Studio is remove rows with (exact) duplicate values in se…
Categories
Popular tags
- Release notes 183
- Aperture Data Studio 149
- Functions 61
- Find Duplicates 59
- Workflows 36
- Datasets 36
- REST API 34
- Data Studio 32
- feature demos 26
- dmx 26
- tips and tricks 19
- Rules 18
- JDBC 17
- v2.14 15
- Community Challenge 15
- v2.8 14
- Automations 14
- Extensions 14
- v2.12 14
- Downloads 14
- v2.11 13
- datasource 12
- Transform 12
- Notifications 12
- v2.5 12