Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Match RecordsGood Day, I have two datasets can I match them and get the records that matches either by company n…
-
Can I integrate Aperture with CollibraIs it possible to Integrate Aperture to Collibra? And then showcase the Rules created in the Apertu…
-
Can I Consume API in Aperture?How can I consume API in Aperture or how can I read/parse XML or JASON in Aperture
-
Scheduling workflows using the Data Studio REST API in version 2In v2.0 of Data Studio, the REST API has changed from v1, so this original post has been updated fo…
-
IF then ELSE LogicCan I write IF (Some Condition)THEN (Valid) Else (Invalid) Logic in Aperture? So That in the Output…
-
Has anybody used Aperture to anonomise/create synthetic data?I have a requirement to create anonymised/synthetic data My initial thought, for the name, would be…
-
How do we expand on the provided base blocking keys and rule sets on Aperture Data Studio?Hi team I am asking this question on behalf of one of our Credit Services team members. They are lo…
-
Explore option on Report ObjectHi, Am using a report object for dashboard and the explorer is not showing to be able to filter
-
Single Customer View (SCV) user research interview invitationHi all, At Experian we are always looking to improve our technology and processes to give you the b…
-
Creating new schedule with cron expression ?Hi, I try to make new schedule every month for the time intervals from 10th to 15th and 25th to 30t…
-
XML filesHI, I'm trying to read selected fields from an XML file pulling out, for example, text between the …
-
How to Execute Parallel Workflows (without Custom Steps or Powershell)Hi all, The Setup: Aperture V2.2.8 on Windows Server 2012 R2 Current Situation: I have to run 8 di…
-
Convert Pass and Fail to 0 and 1Hi, Is the a quick way to transform Pass and Fail validations to numbers 1 and 0 respectively Regar…
-
How to convert unix timestamps to human-readable date?Hi, Does any one know how to convert Unix timestamps to human-readable date? Example Unix timestamp…
-
4009: Exception occurredWhen filtering on a field I get an error 4009: Exception occurred
-
XML driver for ApertureHi, Does anybody on the forum know if it is possible to read semi-structured XML data into Aperture…
-
ℹ️ Scoreboard Charts for DashboardsCharts can be created as bar charts, line charts, pie charts etc. These charts can be collated toge…
-
Notifications in Aperture - email contentHi everyone! I have a question related to the email content on the notifications section. We are tr…
-
Calling subroutinesHi, When there are more that 1 outputs from a subroutine is it possible to distinguish them in the …
-
Aurora database connection?Hi, Our client MDM has been built on an aurora database platform. Is there a connector for Aperture…
-
Salesforce - User connection propertiesHi all, If we add a new column to a Salesforce table and refresh the data, it doesn't bring the on…
-
Find Duplicates Language for Notepad++If you're using Notepad++ as your text editor, it can be helpful to have an interpreter to highligh…
-
👪 Parse Full NameSummary The functions contained within this package are all designed to help you in dealing with na…
-
Data source and "Filter regular expression" - How it works?Hi, does anyone know how System -> External systems -> "Filter regular expression"…
-
Undo and RedoIn Aperture Data Studio Version 1, we had the Undo and Redo menu options while creating or editing …
-
Offensive Words 🤬Summary The functions contained within this package all relate to flagging and dealing with data co…
-
Mask Out Email/Phone 🛡️Summary This package contains 2x functions to help with anonymising certain input values, whilst le…
-
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…
-
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 …
-
Challenge 3 - It's a Date!This latest challenge is all about dates. The sample dataset highlights a common challenge many of …
-
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…
Categories
Popular tags
- Release notes 190
- Aperture Data Studio 154
- Functions 61
- Find Duplicates 59
- Datasets 41
- Workflows 39
- REST API 35
- Data Studio 33
- feature demos 26
- dmx 26
- tips and tricks 21
- Rules 18
- JDBC 17
- v2.14 15
- Community Challenge 15
- Automations 15
- datasource 14
- Transform 14
- v2.8 14
- Extensions 14
- v2.12 14
- Downloads 14
- validation 13
- v2.11 13
- export 12