Data Cleansing

Discussion List

• Flattening out / Pivoting / Transforming results

  Hi, I'm having an issue flattening out results. Essentially, I have multiple rows for the same cust…

  Answered 44 views 4 comments 0 points Most recent by Josh Boxer September 2024Support
• Error attempting to delete match store

  Hi, In my project, we are using Experian Aperture Data Studio(2.10.10) to connect to a Remote Find …

  Answered 109 views 9 comments 1 point Most recent by Shreya April 2024General
• UK Postcode formatter 🏡

  Summary This package contains a single function but may be updated in the future to include others.…

  133 views 4 comments 0 points Most recent by Lucy January 2024Functions library
• Handling data from Experian Aperture Data Studio jobs

  We are getting error in the execution of Experian scheduled jobs as "There is not enough spac…

  Answered ✓ 38 views 2 comments 0 points Most recent by Josh Boxer August 2023General
• Error while connecting to Embedded Duplicate Store

  Hi, I am getting error as below when I am trying to connect to the Embedded Duplicate store in my D…

  Answered ✓ 81 views 2 comments 0 points Most recent by Shreya May 2023General
• Spelling Check

  I've quite a few datasets that have spelling problems or words with number instead of a letter and …

  Answered ✓ 35 views 4 comments 0 points Most recent by Marco_13112001 April 2022General
• Extracting titles and honorifics from names (advanced)

  In this earlier post I described how you might want to extract titles or honorifics from a name str…

  203 views 2 comments 0 points Most recent by Henry Simms October 2020General
• Extract Title from Names

  During the course of the data preparation that you might be doing on names, you might have occasion…

  24 views 0 comments 0 points Started by Clinton Jones September 2020 General