Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
📽 📺 Achieve more with your data - videosOn the Data Studio homepage there is a widget named 'Achieve more with your data' that gives access…
-
Drop zone configuration in server.propertiesHi Team, Can we configure customize datadropzone folder at different shared location same as export…
-
Next ⏭️📅 & Previous ⏮️📅 Working DaySummary The 2x functions contained within this package relate to identifying the last working date …
-
Last day / working date of month 📅Summary The 2x functions contained within this package relate to identifying the last date of the m…
-
Finding database / table attributesHi, Is there a way of creating an output of all the fields and attributes of a table / database. I …
-
finding previous day recordHi, I have a file of daily transactions where I find details of the latest record using Max date. H…
-
Calculating the difference between values on separate daysHi, I have created a grouped output which counts the number of loans per day as below. How do I cal…
-
Connecting to D365 with OAuthCan someone tell me what the settings are for the below when accessing D365 Authentication paramete…
-
Migrating Aperture Studio from one VM to anotherHi, We are trying to migrate Aperture studio installation from 1 virtual machine to another. Could …
-
How to promote from dev to prod environments when using different external systemsProblem: I’ve recently been working with a client who had used their Data Studio development enviro…
-
We need your feedback on Find DuplicatesHi all, We are evaluating the paths to a better Find Duplicates rule building experience. We unders…
-
🎞️ A demonstration on data maskingData Studio can suggest the hashing or masking of data based on a combination of data tagging and s…
-
-
Replacing the string value with Null if the end of the string matches with the LOVI have company names in a field I want to replace the end of the company name with Null if the name…
-
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…
Categories
Popular tags
- Release notes 169
- Aperture Data Studio 146
- Functions 61
- Find Duplicates 59
- Workflows 35
- Datasets 34
- Data Studio 32
- REST API 31
- dmx 26
- feature demos 26
- tips and tricks 19
- Rules 18
- v2.14 15
- JDBC 15
- Community Challenge 15
- v2.8 14
- v2.12 14
- Extensions 14
- Automations 13
- v2.11 13
- Downloads 13
- Notifications 12
- Transform 12
- datasource 12
- v2.5 12