Learn, collaborate and solve problems with like-minded data quality enthusiasts.
The Data Quality Community is a great place to collaborate, seek answers, and learn Aperture Data Studio. Register for free to join in with discussions.
Dear Aperture Data Studio users, I hope you had a great bank holiday! We’re excited to share a quick update to the Experian Learning platform (specifically the Aperture Data Studio area) and invite you to showcase what you’ve learned. We recently enhanced the platform with shareable learning achievement badges, and a…
We’ve recently created a short series of 8x 3 minute feature demos showcasing core capabilities of Aperture Data Studio. These videos were originally developed to support global analyst briefings and technical deep‑dives, and we’re now sharing them with the Community to help increase awareness of Aperture’s functionality…
Hi, I have an ID column I want to add a group/cluster ID column for them. So if they have the same ID they would have the same cluster ID. Would be grateful for a solution. Thanks!
Experian’s NCOA process helps organisations identify customer address records that may need to be updated, suppressed or handled sensitively. The process compares the customer name and address details supplied by the client against Australia Post National Change of Address information. The results are returned in three…
Purpose This article provides a recommended approach for interpreting Experian Email and Phone Validation results and converting them into practical downstream actions. The goal is to help teams decide whether a contact point should be accepted, rejected, corrected, retested, or manually reviewed. Experian’s validation…
Purpose Australian organisations are often used to a strong address capture experience: a customer starts typing, address suggestions appear, and the correct address can usually be selected quickly. That experience works well in Australia because address coverage is strong and the user journey is familiar. Globally,…
Have set up a new connection to a different D365 instance in the same environment and getting the following error Caused by: com.experian.aperturedatastudio.jdbc.dynamics365.phoenix.sql.ae: The specified session options do not match the options used to initially create the schema map. Either change the option values or…
Hi, I have a simple question (I hope). I have a column that have multiple different values. Out of the 2 values are 'PC' and 'PCE'. I am using the replace function the convert 'PC' into 'PCE'. However it takes the PC part form the already existing PCE and makes PCEE. Any advice how to make the replace step take the exact…
I'm working on a data migration project in Aperture with approximately 447 datasets, many of which are reference or lookup tables. I'm looking at options for automating dataset refreshes and would be interested to hear what approach others have taken when managing a large number of datasets: Adding datasets individually to…
Please could anyone help, in the eLearning, there is a link presented a few times but it doesn't appear to take you to the correct place. Example in Lesson 2 Combining Sources, Join Types, you are asked to click a button "Documentation" and "select the "Join" Tab from the dropdown manu.. but pressing the button takes you…
Hi, I'm looking for a solution for en example on the left side of the screenshot. I want to merge the values from Column 1 for the same ID (expected solution on the right). Would be very grateful for any suggestions :)
Hi, I am looking for an elegant solution in Aperture. The top part of the screenshot is example data. I need a way that if in column 6 or 8 the value is >0 then create a copy row with these values, set the original ones to 0 and in column 4 there will be a hard-coded new value "1003" for such cases. Does anyone have a…
