Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Aperture data studio log file locationHi, I have noticed something now in our prod servers. The log file generated for aperture data s…
-
Importing data form a cloud-based MDM solutionHi, We need to import data into Aperture Data Studio from Boomi’s Master Data Hub module. As a clou…
-
Word FrequencyEvery now and then a scenario crops up where it'd handy to know how often a given word occurs withi…
-
Is there an function to identify extra spaces between words?Hi, I would like to check if is there any out of box solution for identification of extra spaces be…
-
-
How to convert a value using if-then-else?Hi, I've created the following function to convert an input to zero if the input equals to null an…
-
SAP Views as DatasetsHas anyone used SAP views as a datasets? I have a strange situation where SAP View can be defined t…
-
Parse Date 🧽📅Parse Date This function is designed to have flexibility to accommodate all sorts of different dat…
-
How to export line breaks?Dear All! In the workflow I'm running I have loaded a dataset (from excel) containing line breaks. …
-
Huge HPROF file in installation folder.java_pid2376.hprof What is an HPROF file and what is it doing in my ADS installation folder. C:\Pro…
-
Challenge 4 - Cleaning product (data)Want to test your Aperture Data Studio skills a little more? This next challenge requires you to an…
-
2 questions on TRANSFORMLooking for ideas from community. 1) Transform – ‘Equals’ Command I am in a workflow to check if …
-
Filtering within a validation ruleHi, I have the following scenario for a validation rule and I'm struggling with the logic. Column…
-
Workflow not completed - notificationHi All! Is there a way to set an (e-mail) notification in case a workflow has been stuck? Meaning …
-
Schedule for every 2nd weekHi All! I've set a schedule for a workflow with the following criteria: Recurrence pattern: weekly …
-
Notifications based on emails in the dataWe have 50 service desks placing orders for customers around the country. We want to monitor those …
-
Equals (Strict) functionIs there any documentation on the functions? I am looking for explanation for Equals (Strict) Funct…
-
How to determine Nth occurence in a column?Hello. Do you know of any function or combination of functions that can achieve a new column in the…
-
Anyone using SAP Tables with LRAW type columns (Example: STXL)We need to bring in SAP STXL table to Aperture. This has an LRAW type column named 'Data'. This is …
-
What are the limits of data loading in Data Studio?Back in June, I read an internal post by @Henry Simms that suggested that in test we had loaded 16…
-
How to highlight null/empty valuesWhen performing exploratory data analysis, or presenting data in grids in a dashboard, you may want…
-
NI No ValidationHi, Can somebody please advise on the algorithm used in the NI No (UK) validation step. I am findin…
-
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…
Categories
Popular tags
- Release notes 190
- Aperture Data Studio 152
- Functions 61
- Find Duplicates 59
- Datasets 40
- Workflows 37
- 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
- Downloads 14
- datasource 14
- Extensions 14
- Automations 14
- v2.12 14
- v2.8 14
- Transform 13
- v2.11 13
- export 12
- v2.5 12