Experian Data Quality Community

Discussion List

• Jobs with large lookup files

  At St. James's Place, prior to highlighting whether client details need to be quality checked, we n…

  82 views 9 comments 1 point Most recent by Henry Simms September 2019General
• Dealing with PII

  Talking to a prospect today about PII - identifying it on data loaded into the system and then proc…

  Answered ✓ 180 views 3 comments 1 point Most recent by Danny Roden August 2019General
• When should I use a Match Lookup rather than a join

  I have a large amount of data (hundreds of millions of transactional records) that I need to match …

  Answered ✓ 180 views 7 comments 1 point Most recent by Clinton Jones August 2019General
• What's better invalid data or missing data?

  A discussion that seems to come up from time-to-time is, whether it is better to have gaps in your …

  Answered ✓ 25 views 2 comments 2 points Most recent by Danny Roden August 2019General
• Extract a number (6-char SIC code) from a string and perform a lookup (2-char SIC to get category)

  Using some of the Company's House open data, I recently built a simple workflow that extracts the S…

  126 views 1 comment 1 point Most recent by Clinton Jones August 2019General
• Floating Point numbers with Microsoft Excel Open XML Spreadsheet (.XLSX) files

  When using .XLSX files in Aperture, be aware that floating point numbers will be treated differentl…

  2K views 0 comments 4 points Started by Sean Leoszko August 2019 General
• The importance of profiling when using Find duplicates

  When implementing Find duplicates in Aperture Data Studio we've seen many examples of the importanc…

  199 views 4 comments 4 points Most recent by Danny Roden August 2019General
• Great article on building loyalty with a Single Customer View!

  Just sharing a great article written by @aysha_aktemur on how Aperture Data Studio empowers loyalty…

  53 views 0 comments 2 points Started by Tanj Jagpal August 2019 General
• How to request a license key

  24 views 0 comments 0 points Started by Clinton Jones August 2019 General
• Removing an unwanted intermittent string from the start of an alphanumeric field

  At St. James’s Place we needed to remove a string, that occurred intermittently, from the start of …

  169 views 6 comments 3 points Most recent by Clinton Jones August 2019General
• What happened to the Python step in Data Studio?

  In Data Studio v1.1 there was a Python Step - what has happened to that and what are the options fo…

  Answered ✓ 86 views 3 comments 0 points Most recent by Henry Simms July 2019General
• I cannot access any files I previously loaded through Data Explorer

  Sometimes you will find that the view of files in the data explorer is out of sync with what is sto…

  20 views 0 comments 0 points Started by Clinton Jones July 2019 General
• Working with Dates

  I have a set of data that contains some dates What I would like to do, is split the day, month and …

  127 views 0 comments 1 point Started by Clinton Jones June 2019 General
• How do you work out where the row comes from ?

  When you're combining data from multiple data sources that potentially have duplicated data, you ma…

  20 views 0 comments 1 point Started by Clinton Jones June 2019 General
• Solving for literal null values

  Depending on the source that you are working with, you may find that you actually have literal null…

  127 views 0 comments 3 points Started by Clinton Jones June 2019 General
• Dealing with character sets

  Sometimes, the file that want to use with Data Studio will contain characters that would come into…

  25 views 0 comments 1 point Started by Clinton Jones June 2019 General
• Fuzzy Matching logic

  How does the fuzzy matching in the Find Duplicates step work?

  350 views 1 comment 1 point Most recent by Akshay Davis June 2019General
• Find Duplicates Step configuration

  What is the difference between the Name, Household and Address/Location choices in the default Fin…

  54 views 1 comment 0 points Most recent by Akshay Davis June 2019General