Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
How to set up an export file name based on a fixed or variable inputIn this article, we will be exploring a number of ways to set up an export file name. Imagine you s…
-
How to append leading or trailing zeroes to a numberAperture makes it very easy for you to append a chosen character to any value to achieve an overall…
-
What "4016: Functions exception occurred" means?Hi, I'm creating a workflow with a large set of validation rules (110 rules and 74 groups) and whe…
-
Documenting Aperture Data Products with MetadataIn complex Aperture environments, like in any data environment, you need to understand what data yo…
-
Creating charts from workflowI've added a chart step to one workflow but when running it I cannot see the chart under the chart …
-
Oracle Java SEHi, Does Aperture data studio and Find Duplicates installers has embedded java installer that upda…
-
How to do pivot Column to rowsI have rule1, rule2, rule3 in the column names and corresponding count in the rows, now I want to g…
-
Harmonize Duplicates - Select best record based on score with multiple criteriaA customer posted this question to me: "I want to pick a survivor using multiple score based c…
-
Format number to 2 DPsI have some data that I'm importing and I want to convert to currency format nnn.nn - there doesn't…
-
Spelling CheckI've quite a few datasets that have spelling problems or words with number instead of a letter and …
-
How to remove leading or trailing charactersHere's a simple example of how you can remove leading or trailing characters. Assume you have loade…
-
Remove rows that have null value?I'm creating a dataset from a snapshot and I would like to remove rows that have null value on a sp…
-
Not been able to drill down from a view created from profile data stepI've created an interactive view from the profile data step however, after publishing the view I'm …
-
Group step in Workflow throws java.lang.IllegalArgumentException: Invalid handleHello there, I have a workflow in Experian's Aperture Data Studio (version 2.5.11.115) which unions…
-
Low Disk Space Notifications and others.Hi team, this is to ask you if I create a low disk space notification on aperture data studio syst…
-
Find Duplicates Blocking Keys and Rules in v2If you have the license for Find Duplicates Fuzzy matching then you could use this functionality to…
-
Setup Secure SSL using self-signed certificatesIs anyone able to provide some clear instructions on how to generate and install a self signed cert…
-
APIs to get the details regarding Data set and wf schedulesHow do I get Information about all the datasets refresh which have been scheduled and timing of tho…
-
Find Duplicates Training DataAttached is data to be used with Find Duplicates Training.
-
I want a column to only accept 'A, 'B', 'C' or 'D' as the correct values.I want to restrict the values for a certain column. It should only accept either 'A, 'B', 'C' or '…
-
How to check if an input value contains numbersIn Aperture Data Studio, in order to check if an input value contains numbers, you can use the Matc…
-
How to validate US dates stored as YYYY-MM-DDI have several fields that have dates stored in the format above. If I run the built in function &q…
-
Find Duplicates Service Installer FAQHere are some FAQs on the Find Duplicates Service Installer available since Aperture Data Studio v2…
-
Find Duplicate - Based on different criteriaHello, Requirement is find the duplicates based on 3 different criteria - Name and Phone Match Na…
-
Even after license renewal, self service portal shows 0 credits for service calls.Even after license renewal, self service portal shows 0 credits for service calls. How can we reso…
-
Aperture API to get the health of the system CPU UsageCan we get the health of the environment through API? What is TenancyID? how can we get the CPU us…
-
Find Duplicates - Address Element MappingHi I am trying to find duplicates in data from multiple countries. I'm mapping company name to &qu…
-
Setting up a parameter to work across multiple workflowsHi, I have a workflow parameter that feeds into both a column and and export. The problem I have is…
-
Issue with Views when upgrading to v2.6.3, v2.6.4 and v2.6.5We are aware of an issue that affects some installations of Aperture Data Studio versions 2.6.3, 2.…
-
Calculate the distance between two sets of co-ordinates 🌍️ Summary Returns the approximate distance in kilometres between a pair of geographical co-ordinates.…
-
Force workflow failure due to failing rowsIs there a way I can force a whole workflow to fail as a result of failing rows in a validation ste…
-
Performance decrease since upgrade to version 2.6I have experienced significant performance decrease since I upgraded Aperture from 2.4.9 to 2.6.0. …
-
Enabling LDAPIn case you haven't noticed, LDAP has been introduced since Aperture Data Studio v2.0.11. Go to Set…
-
How do I determine which version of Aperture I am running pleaseLooking at the Downloads and Release Notes for 2.6.2 I cannot see any link to the download. There …
-
Issue with dates being read as American datesI am pulling in my source data with a column that contains dates of the format dd/mm/yyyy. When ann…
-
Critical vulnerability in Apache Log4j libraryOn 9th December 2021, Proof-of-Concept exploits for a new critical zero-day vulnerability affecting…
-
Tips and Tricks to make Find Duplicates Blocking Keys and Ruleset more readableWhat is your first impression of the blocking keys and ruleset definitions required for Find Duplic…
-
Tune Rules with Find Duplicates WorkbenchThe Find Duplicates Workbench provides you with the capability to tune your Find Duplicates rules u…
-
Identifying two names in a single string with the DelimitedField filterSometimes, the names data you have collected may not be in the best form to be parsed or standardiz…
-
Maximum cluster sizeFind Duplicates comes with a default setting for maximum cluster size at 500. This setting is there…
-
What is the history of Aperture?From a background perspective, what is the technical history of the product? Meaning was it built…
-
Is anyone doing Change Data Discovery in Aperture?In Pandora, detecting changes in different versions of source data was relatively simple - one adde…
-
Importing DataSets - Filtering DataHi, I was wondering if there is currently anyway of limiting/filtering out data from an underlying …
-
Installation of Find Duplicate Different InstanceCan you please help me with the instruction link for installing Find Duplicate Workbench a separate…
-
Find Duplicates - Standardize Name and AddressWhen setting up your Find Duplicates step, the match column allows you to determine which columns y…
-
Aperture compatibility with .NET 4.8Hello support team, I hope you're fine. We need to do an upgrade to .NET 4.8 According to this arti…
-
Is anyone connecting Aperture to an Oracle 10G database pleaseI am looking to connect Aperture to a number of Oracle 10G databases and a number of rather old SQL…
-
Filtering Data on loadIs there a feature in Data Studio to filter data from an external system load - i.e. Select X from …
-
Dashboard Custom content widgetThe Dashboard Custom content widget allows you to add information such as text and links that might…
-
Find Duplicates with Phonetic ComparatorsWe now have the new phonetic comparators (Soundex, NYSIIS and Double Metaphone) for Find Duplicates…
Categories
Popular tags
- Release notes 169
- Aperture Data Studio 146
- Functions 61
- Find Duplicates 59
- Workflows 35
- Datasets 34
- Data Studio 32
- REST API 31
- dmx 26
- feature demos 26
- tips and tricks 19
- Rules 18
- v2.14 15
- JDBC 15
- Community Challenge 15
- v2.8 14
- v2.12 14
- Extensions 14
- Automations 13
- v2.11 13
- Downloads 13
- Notifications 12
- Transform 12
- datasource 12
- v2.5 12