Experian Data Quality Community

Discussion List

• 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…

  121 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…

  1.9K 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…

  191 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…

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

  21 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 …

  161 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 ✓ 71 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…

  17 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 …

  121 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…

  16 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…

  123 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…

  21 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?

  331 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…

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