Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
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…
-
How to assign a variable value to a new column created in TransformI am creating a new column (X) in Transform and I want to assign the value I created in the previou…
-
How to assign a variable value to a column valueI want to assign the value of a column to my Workflow Parameter value. Ex. I have list of the colum…
-
Match RecordsGood Day, I have two datasets can I match them and get the records that matches either by company n…
-
Can I integrate Aperture with CollibraIs it possible to Integrate Aperture to Collibra? And then showcase the Rules created in the Apertu…
-
Can I Consume API in Aperture?How can I consume API in Aperture or how can I read/parse XML or JASON in Aperture
-
Scheduling workflows using the Data Studio REST API in version 2In v2.0 of Data Studio, the REST API has changed from v1, so this original post has been updated fo…
-
IF then ELSE LogicCan I write IF (Some Condition)THEN (Valid) Else (Invalid) Logic in Aperture? So That in the Output…
-
Has anybody used Aperture to anonomise/create synthetic data?I have a requirement to create anonymised/synthetic data My initial thought, for the name, would be…
-
How do we expand on the provided base blocking keys and rule sets on Aperture Data Studio?Hi team I am asking this question on behalf of one of our Credit Services team members. They are lo…
-
Explore option on Report ObjectHi, Am using a report object for dashboard and the explorer is not showing to be able to filter
-
Single Customer View (SCV) user research interview invitationHi all, At Experian we are always looking to improve our technology and processes to give you the b…
-
Creating new schedule with cron expression ?Hi, I try to make new schedule every month for the time intervals from 10th to 15th and 25th to 30t…
-
XML filesHI, I'm trying to read selected fields from an XML file pulling out, for example, text between the …
-
How to Execute Parallel Workflows (without Custom Steps or Powershell)Hi all, The Setup: Aperture V2.2.8 on Windows Server 2012 R2 Current Situation: I have to run 8 di…
-
Convert Pass and Fail to 0 and 1Hi, Is the a quick way to transform Pass and Fail validations to numbers 1 and 0 respectively Regar…
Categories
Popular tags
- Release notes 162
- Aperture Data Studio 142
- Functions 59
- Find Duplicates 59
- Workflows 35
- Datasets 34
- Data Studio 32
- REST API 31
- feature demos 26
- dmx 25
- tips and tricks 19
- Rules 18
- Community Challenge 15
- v2.14 15
- JDBC 15
- v2.12 14
- v2.8 14
- Extensions 14
- v2.11 13
- Notifications 12
- Automations 12
- Transform 12
- datasource 12
- Downloads 12
- v2.5 12