Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Tell us what we can do to improve your Aperture Data Studio administration experienceHi everyone, We have created a survey for you to share with us your opinion on your Aperture Data S…
-
Ensuring you always return the same duplicate ID with Find DuplicatesFind Duplicates returns consistent Cluster ID after each run. Consistency here applies to the seque…
-
Tagging - remove tagsHi I have workflows that have columns with tags. When l union because not all the columns tagged th…
-
Profiling Data for the first time and changing the underlying data(File) This short video illustrates the ease with which you can define a dataset, profile the data …
-
Cleansing FieldsHi I have fields that are quite messy when l receive them. We will be going back to source and clea…
-
EdgeHi, Overnight Edge (the company default browser) has been upgraded - does this improve things for A…
-
Splitting full name - Last nameHi I have Full name fields, data is all represented in one field and l need to split this out to Fi…
-
Delta Data loads - Aperture v2.0Hi this is a follow on from the delta data loads for version 2.0. Not sure if a better way in v2.0.…
-
Address Validation v 2.1I am blown away by the speed of the Batch Address Validation processing on NA addresses in this rel…
-
Address RationalisationHi all I am looking for an example of splitting an address into the different parts. I have an ad…
-
Split data from two columns - phoneshi I have a situation when l have a file that has two columns with phone data: Phone …
-
Phased deployment and secure collaboration in Aperture Data Studio v1 vs v2In Aperture Data Studio v1, there isn’t an effective way to compartmentalize objects such as datase…
-
Address validation - format the column firstHi I have a postal address column that has the data in one column and is in this format: 1 Smith St…
-
Phone Format - Australian LandlinesHi I have used the following to format australian formats (Image) Landlines can be in this format:…
-
Data ImprovementsHi I have a dataset that has the following fields (as a subset): First Name Middle Names Surna…
-
Fixed Width file parsing in Aperture Data Studio v1 versus v2Fixed width files may be one of the common file formats that you have come across and need to proce…
-
Salesforce tables have different columns after upgrading from Data Studio v1 to v2If you've previously used Data Studio v1 to load data from your Salesforce instance, and have upgra…
-
Phone numbers - consistent formattingHi I have phone numbers within applications that can be in many different formats for landlines and…
-
Automation of datsource as a datasetHi We have created a datasource that will update on periodic basis. To set this up to a workflow, l…
-
Formula - converting values into a field to another columnHi I would like to convert columns that we receive from an application and place into columns that …
-
Scheduling errorGood afternoon Relatively new to v2 so apologies if this is a user error problem ! I am trying to s…
-
JDBC connectionHi Can you please let me know if there is/planned to be a JDBC connection for Optymyze? Thanks Nige
-
Function to calculate the number of working days between two datesRecently I wanted to create a function in Data Studio to calculate the number of working days betwe…
-
Edit DistanceIn the Edit Distance function with Levenshtein or Jaro-Winkler we have a field "Length" …
-
Anyone got the Azure Blob Storage Datasource connection workingIf so, what URL did you use? Couldnt find documentation around this. Thanks for answering
-
Duplicate Match Status ConverterThis is not a difficult thing to do but is a bit time consuming. Find Duplicates Match status is nu…
-
All Find Duplicates Pre-built RulesetsThis dmx file will import all the Find Duplicates default rulesets. These are pre-built rules and b…
-
Default Find Duplicates RulesetsAnother quick shortcut. This dmx file will import all the Find Duplicates default rulesets. These a…
-
How to systematically sample with a fixed sample size and varying population sizeI was recently asked how to build a Data Studio workflow that would output a systematically sampled…
-
Data Studio v2.0 - Rest API - trigger workflowsHi For the script where is states: >Powershell {path}\apertureExecuteWorkflowv2.ps1 -environment…
-
-
Find Duplicates Blocking Keys and Rules in v2If you have the license for Find Duplicates Fuzzy matching then you could use this functionality to…
-
Enabling LDAPIn case you haven't noticed, LDAP has been introduced since Aperture Data Studio v2.0.11. Go to Set…
-
What is the status of data catalog integrations, for example Collibra?What is the current status of Aperture to Collibra-integration? https://marketplace.collibra.com/pr…
-
De-Duplication DateCompareHi, I am having trouble implementing the "DateCompare" comparitor and was wondering if so…
-
Setting up custom Find Duplicates rules@Carolyn asks I would like to set up a custom Find Duplicates - Not sure how to set up Find Duplic…
-
Welcome to the new look Experian Data Quality Community! What's new?You may have noticed a few changes! We have been busy working behind the scenes to introduce new fe…
-
Adding a variable comment as a "call to action" for data quality issues foundThis is an experiment on handling HR data quality issues using a validation workflow in Aperture Da…
-
Specifiy or select non default schema when pulling external source from Azure SQL server using JDBCIn previous versions of Aperture Data Studio is stated that their were bug fixes related to SQL Ser…
-
Updating multiple keys after de-dupGood Morning, I have recently ran a de-duplication process and have a good set of cluster ID's. Wi…
-
De_Dup failingAnyone any ideas ? (Image)
-
Data Studio v2.0 - Export JDBC Error 9002Hi We are trying to export data back to database. We have updated the export definition as follows:…
-
Split Column - 2 columnsHi I have a file that has a column for postal address that is in this format. Using V2.0 Data Studi…
-
Data Studio V2.0 Find DuplicatesHi Thank you for the answers around using Find Duplicates Workbench. I will investigate this long t…
-
SSIS and ApertureIs it feasible to embed an aperture task within a scheduled SSIS job? This would be used in the ini…
-
Data Studio v2.0.10Hi, We’re pleased to announce the release of Data Studio v2.0.10. You can get an internal copy of…
-
Data Studio V2.0 - Trend Analyse & Data Consumer DashboardsHi On the help documentation, there is no update on Trend Analyse and Data Consumer Dashboards If t…
-
Data Studio V2.0 - External System ConnectionsHi When you set up an External System Connection it will only appear under the workspace you create…
-
AWS database connection issues to Aperture (v1.6.4)Hi, Does anybody have any suggestions why a database can arbitrarily flip-flop between connecting t…
-
Data studio v2.0 - trigger workflowsHi In version 1.6.1 the way to trigger workflows was to setup the yaml file. How do you setup trigg…