Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
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…
-
Challenge 2 - Title Casing SurnamesDoes it bother you when you get mail through the letter box and your name is not presented with ‘st…
-
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…
-
Community guidelinesWe welcome you and your views in our community! We want to make this a positive, safe and vibrant p…
-
How to earn points, badges and to increase rankThe Experian Data Quality Community isn't about the volume of discussions and questions but about t…
-
How to register and manage your accountYou need to register to post and comment, but don’t worry - it takes a couple of minutes. Click Reg…
-
Welcome to the Experian Data Quality Community 🙌 Welcome! At Experian, we’re extremely proud of our data quality solutions, and we've set up this c…
-
APIs in Aperture Data Studio v2In v1 there were a number of APIs for the automation of UI as outlined here under the REST API guid…
-
Grouping in V2 and differences with V1if you're working with financial data with Aperture Data Studio, one of the things that you might w…
-
Reading files without headers - then scheduling the jobHi We would like to use Aperture (currently using v1.6.2) to read a series of files that are sent o…
-
The title field is requiredBody is 1 character too short.
-
Code going missing in a v1.x job?Hi Are any other users experiencing the frustration of sections of code going missing? We (@Pavan …
-
2020 Global data management researchExperian recently released its annual global data management benchmark report. This year we surveye…
-
Using a network path for the server import or export directoryIt may be desirable to have Data Studio v1 or v2 import and export data from a network path. This w…
-
Data Views - an abstracted view of your data sourcesAn entirely new concept of data views based on datasets is introduced in V2.0. Views enable designe…
-
Handling Gmail email addresses for duplicate identificationThe problem: Gmail allows multiple e-mail addresses for a single account With over 1 billion active…
-
User Spaces - a way to organize your workAn entirely new concept of user spaces is introduced in V2.0. Spaces enable designers of workflows…
-
Environments - giving your Data Studio installation more flexibility with sandboxesOne of the characteristics of business-critical systems is that they need to be secured in such a w…
-
Democratizing and controlling data access in v2.0Data Studio v2.0 provides a sophisticated and secure architecture for exposing data to the enterpri…
-
Connecting to an SMTP email server that does not require authenticationData Studio lets you configure an SMTP server connection, which can then be used to send email noti…
-
Scheduling workflows using the Data Studio REST APIAperture Data Studio is intended to be invoked from third party schedulers , like Windows Task Sche…
-
Hello world...🥂 our developers have been hard at work and we are stoked about this new release. Prod your account…
-
Inferring Gender from Title or Honorific and Gender ReversalSometimes it might be useful to determine the gender of a person from their honorific, so for examp…
Categories
Popular tags
- Release notes 183
- Aperture Data Studio 149
- Functions 61
- Find Duplicates 59
- Workflows 36
- Datasets 36
- REST API 34
- Data Studio 32
- feature demos 26
- dmx 26
- tips and tricks 19
- Rules 18
- JDBC 17
- v2.14 15
- Community Challenge 15
- v2.8 14
- Automations 14
- Extensions 14
- v2.12 14
- Downloads 14
- v2.11 13
- datasource 12
- Transform 12
- Notifications 12
- v2.5 12