Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Configuration of a dropzoneHi, We are working on the plan for integrating an application and Aperture. The latest was that a …
-
Address Validate with Business DataHi When comparing QAS Batch with Aperture Validate Addresses to enhance data, I notice that Apertur…
-
Renaming the Datasets and share to other Spaces togetherIs there a quick way to rename all the datasets together. Example wants to add some prefix to all d…
-
Experian Data Studio Job Stuck.Hi, One of the experian data studio job is stuck for 23h on our dev server, we have tried to cance…
-
FunctionsHi, I'm working with Functions. Re:product development, it would be a really useful to be able to m…
-
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…
-
How to export line breaks?Dear All! In the workflow I'm running I have loaded a dataset (from excel) containing line breaks. …
-
Best practices designing complex WorkflowsA Workflow is a sequence of steps that defines a process to transform and manipulate your data. Whe…
-
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…
-
Suggest Validation rules - Validate stepAperture Data Studio has a Validate workflow step that allows you to define rules of how data in sp…
-
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…