Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Critical vulnerability in Apache Log4j libraryOn 9th December 2021, Proof-of-Concept exploits for a new critical zero-day vulnerability affecting…
-
Email notification of new Aperture Data Studio releasesIn order to get notified of new Aperture Data Studio releases, you can follow the Downloads and Rel…
-
Aperture Data Studio Hosted and Managed Service Maintenance ScheduleFor our customers on the Aperture Data Studio Hosted and Managed Service: The maintenance schedule …
-
Performance decrease since upgrade to version 2.6I have experienced significant performance decrease since I upgraded Aperture from 2.4.9 to 2.6.0. …
-
Issue with dates being read as American datesI am pulling in my source data with a column that contains dates of the format dd/mm/yyyy. When ann…
-
Connecting to hosted Dynamics 365 with OAuth2Data Studio’s Dynamics 365 connector can be used to read or write data from Microsoft Dynamics 365 …
-
Is anyone using Aperture with the Parquet source file format?Parquet is associated with Hadoop but I am not sure whether the Hadoop import setup will read this …
-
What is the history of Aperture?From a background perspective, what is the technical history of the product? Meaning was it built…
-
How to do pivot Column to rowsI have rule1, rule2, rule3 in the column names and corresponding count in the rows, now I want to g…
-
Is anyone doing Change Data Discovery in Aperture?In Pandora, detecting changes in different versions of source data was relatively simple - one adde…
-
Importing DataSets - Filtering DataHi, I was wondering if there is currently anyway of limiting/filtering out data from an underlying …
-
Installation of Find Duplicate Different InstanceCan you please help me with the instruction link for installing Find Duplicate Workbench a separate…
-
Aperture compatibility with .NET 4.8Hello support team, I hope you're fine. We need to do an upgrade to .NET 4.8 According to this arti…
-
Is anyone connecting Aperture to an Oracle 10G database pleaseI am looking to connect Aperture to a number of Oracle 10G databases and a number of rather old SQL…
-
Filtering Data on loadIs there a feature in Data Studio to filter data from an external system load - i.e. Select X from …
-
📽 📺 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…
-
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…
-
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…
-
Relationship Discovery by using Find Duplicates Step in Aperture Data StudioWe tried to find the join candidates across tables and databases by using the profiling metadata in…
-
New Experian Data Quality RoadmapI am delighted to announce that the interactive version of Experian Data Quality's product roadmap …
-
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…
-
Find Duplicate - Based on different criteriaHello, Requirement is find the duplicates based on 3 different criteria - Name and Phone Match Na…
-
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…
-
Format number to 2 DPsI have some data that I'm importing and I want to convert to currency format nnn.nn - there doesn't…
-
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…
-
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…
-
Error when running workflowWhen running a workflow I get the error message - One or more workflow steps are invalid - but no i…
-
Subscribe to Updates on MaintenanceScheduled Maintenance for Hosted Aperture Data Studio is now published in the status.edq.com page. …
-
Australia Machines Maintenance ScheduleThe maintenance schedule for Experian Hosted Aperture Data Studio machines hosted in the Australia …
-
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 …
-
Transform to DecimalAperture 2.3.075 I'm struggling to find a basic and simple function to preserve decimal places when…
-
Importing and Exporting WorkflowsOne of the very first things that you will probably wonder, is just how portable are my workflows t…
-
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…
-
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…
-
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 …