Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Proper Case Surname 📛Summary This package contains 2x functions which help with contact data: Proper Case Surname and Va…
-
Get Word ✂️Get Word Extracts the 'nth' word from a string (where 'n' is defined when the function is executed)…
-
Reasonable Date of Birth (DOB) 🔞Reasonable Date of Birth (DOB) [Category: Validation] This function simply checks the input seems r…
-
Standardise Gmail addresses 📧Standardise Gmail addresses [Cleansing] This function is used to help standardise Gmail addresses f…
-
Job Title Match Key 👨💼👩💼Job Title Match Key The function in this post has been designed to help illustrate an approach (and…
-
Invalid Character for Names ☹️Summary This package contains 2x functions: Contains Only Valid Characters for Names & Contains…
-
Compare Dates (Verbose) 📅📅Compare Dates (Verbose) [Category: Conversion] This function provides a summary of how 2x input dat…
-
Convert Boolean ✅❌Convert Boolean [Category: Conversion] This function converts a binary or Boolean values (i.e. true…
-
Contains Non-Latin Characters 🈯Contains Non-Latin Characters [Validation] This function identifies the presence of any characters …
-
Reverse String ⏪Reverse String If you find yourself needing to reverse a string (i.e. for bespoke building of anony…
-
PCI Detection 💳 (Payment Card Information)Summary The following package is used to detect payment card information (PCI) and whether it is pr…
-
Scheduling in Aperture Data Studio Version 1 vs Version 2Many Aperture Data Studio customers process large volumes of data. Workflows are likely to be sche…
-
SIC Conversion 🏷️Summary The following package is used in processing Standard Industry Classification (SIC) codes, a…
-
Transform node in Aperture 2Hi, I'm trying to use the Transform step in Aperture 2 and am finding that, with the limited number…
-
Identification of an individual flat in a building using Address ValidateHi, I've checked the following address (which is valid with an appropriate postcode) using Address …
-
Connecting to a SAP HANA database using Data StudioFrom the Data Studio v1.6.1 release onwards, we've made it easier to connect to a SAP HANA database…
-
Date formattingI've lost the month in this date format - any suggestions? (not a lot to go on in the help here) Th…
-
SnowflakeWe have been experimenting with Snowflake technology and were wondering whether anybody has experie…
-
SAML anyone?Hi everyone. Our engineering team is currently working on a feature for Single sign on enterprise …
-
Sharing of useful functions to support contact data validationHi all, I've found myself using a few functions on a regular basis so thought I'd share them on her…
-
Using Format Phone NumberI was wondering how everyone uses the function Format Phone Number in Aperture. For myself, I am to…
-
What is the best way to check for the presence of a number value in a field?We often have a requirement from clients to check for numbers in a name field or for name in a phon…
-
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…
-
Automated Data Tagging in v2.1In v2.1 you now have the ability to automatically tag your data using the predelivered data tagging…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
EdgeHi, Overnight Edge (the company default browser) has been upgraded - does this improve things for A…
-
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…
-
✏️ Challenge Index 🔍Each month we're posting a new challenge for you to have a go at to test your data skills. Challeng…
-
Challenge 1 - Gender Title Mismatch DetectionThis first challenge is concerned with identifying records that are displaying inconsistent informa…
-
🏆 How to respond to challenges 🏆Guidance When you've successfully completed a challenge. Make sure you post your solution so others…
-
Open Data Sources by CountryA few open data sources. Feel free to add more. United States: http://www.data.gov/ Austria: htt…
-
💡 Submit a challenge idea 💡We love to hear challenge ideas from our Community members, so if you have an idea that you think w…
-
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…
-
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…
-
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…
-
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…
-
Adding a variable comment as a "call to action" for data quality issues foundThis is an experiment on handling HR data quality issues using a validation workflow in Aperture Da…
-
Setting up custom Find Duplicates rules@Carolyn asks I would like to set up a custom Find Duplicates - Not sure how to set up Find Duplic…
-
AWS database connection issues to Aperture (v1.6.4)Hi, Does anybody have any suggestions why a database can arbitrarily flip-flop between connecting t…
Categories
- All categories
- 17 Get started
- 467 Get involved
- 8 Support
- 269 Resources
- 3 Events
- Upcoming events
- 3 Event recaps
- 18 Ideas and roadmap
- 218 Community categories
Popular tags
- Release notes 139
- Aperture Data Studio 131
- Find Duplicates 59
- Functions 55
- Data Studio 31
- Workflows 28
- Datasets 27
- dmx 24
- feature demos 22
- REST API 21
- tips and tricks 19
- Rules 18
- v2.12 14
- v2.8 14
- Community Challenge 14
- v2.11 13
- Extensions 13
- v2.5 12
- Transform 11
- v2.10 11
- Address Validation 10
- Automations 10
- Dashboards & Charts 10
- blocking keys 10
- validation 10