Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Sign up to the latest data quality webinar "How to eliminate poor CRM customer contact data"Hi all, Experian is holding a free webinar on “How to eliminate the impact of poor CRM customer co…
-
Automated Data Tagging in v2.1In v2.1 you now have the ability to automatically tag your data using the predelivered data tagging…
-
Address ValidationMorning My Address Validation in V2 is no longer working, wont allow me to select "country&qu…
-
Data Stewardship PrioritiesWhen you think about Data Stewardship, what does that really mean to you and what do you think matt…
-
Extract Title from NamesDuring the course of the data preparation that you might be doing on names, you might have occasion…
-
Finding earliest date in a clusterHi I have multiple rows for a customer and each row has a modified on date. I want to find the earl…
-
Trim a leading wordIn this brief clip i will show you how to trim a leading word from a field. In this case i am trimm…
-
Datasetdropzone directory changes in v2.1.2Hi all, I’m writing this post to inform you all on the upcoming change to the datasetdropzone direc…
-
Export directory changes in v2.1.2Hi all, I’m writing this post to inform you all on the upcoming change to the Export directory in v…
-
Harmonisation in V2.0 Data StudioHi Trying to understand the best way to get a better harmonised record, when you have multiple line…
-
Export - JDBC error - formula to ensure a column has a right lengthHi I am loading 1.9 million records back to database and l will often receive this message (part of…
-
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…
-
Notification setup to trigger ScheduleHi I have set up a notification, so when a few datasets are loaded, it kicks of the schedule im str…
-
Upgrading to a new release for Aperture Data Studio v1 versus v2Up until now, we have had 23 releases for Aperture Data Studio v1. In order to upgrade from one re…
-
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…
-
Copy a space - workflows, datasets, exports, snapshots within the same serverHi At moment l have setup a space for single view of customer. Business would like to copy the full…
-
Export to JDBC - not loading but Job completingHi I have an export step that goes to JDBC database. We have another table in the database thats wo…
-
Subtotal of Dataset to Workflow - alertHi Is there away that when a dataset is loaded via datasource or dropzone into Aperture, that when …
-
Attention all V1 & V2 users...Today we have launched a new sub category, Migrating from V1 to V2, which contains posts to aid you…
-
Triggering workflow executions upon file arrival in Aperture Data Studio v1 versus v2Aperture Data Studio is commonly used for operational data quality management. This would mean that…
-
Address Validation v 2.1I am blown away by the speed of the Batch Address Validation processing on NA addresses in this rel…
-
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 dataThis short video illustrates the ease with which you can define a dataset, profile the data to dyna…
-
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 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 versus 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 Landlines can be in this format: 3999988…
-
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…
-
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…
-
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…
-
-
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…