Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Email notification of new Aperture Data Studio releasesIn order to get notified of new Aperture Data Studio releases, you can follow the Downloads and Rel…
-
Aperture Data Studio Hosted and Managed Service Maintenance ScheduleFor our customers on the Aperture Data Studio Hosted and Managed Service: The maintenance schedule …
-
-
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…
-
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…
-
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…
-
How to setup Google Big Query as an external system for pushing data into BigQuery tableHi, Did anybody try using the Google Big Query 6.0 JDBC and know how to configure the credential de…
-
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…
-
NI No ValidationHi, Can somebody please advise on the algorithm used in the NI No (UK) validation step. I am findin…
-
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…
-
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…
-
Documenting Aperture Data Products with MetadataIn complex Aperture environments, like in any data environment, you need to understand what data yo…
-
Subscribe to Updates on MaintenanceScheduled Maintenance for Hosted Aperture Data Studio is now published in the status.edq.com page. …
-
New Status Page for Experian Hosted Aperture Data StudioAs part of an initiative to improve our incident and maintenance communications, we are introducing…
-
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 …
-
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…
-
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 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.…
-
Do you have a need for Pivot/Unpivot steps?As part of our product discovery activities, we would like to find out if any of our clients have a…
-
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 …
-
TLSv1 and TLSv1.1 protocols disabled by default in Data StudioTowards the end of 2021, TLSv1 and TLSv1.1 protocols became disabled by default in Java 8, on which…
-
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…