Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Is there an easy way to filter out records which contain a number only (for a given column)?I need to filter out records which contain a number only from an address column. I have attempted …
-
Error GroupsIs there any way, having set up a number of Error Groups in a workflow, to propagate these into ano…
-
Error when refreshing dataset - "Unable to get tables."I've not seen this error before and I'm unsure how to resolve other than dropping and recreating th…
-
Batch timestamp formatI've created a number of DQ outputs running of a scheduled workflow to create a multibatch dataset …
-
Why doesn't the Replace Matches function work in some specific cases?I am trying to use the Replace Matches function within Aperture, using the Comma Separated Input Ty…
-
Why can't I select a file from an SFTP serverI am trying to Add Dataset from an SFTP server and can see a list of 29 files. I am at the Select …
-
-
Version 2.7.5 Delete dataset bugWe identified a bug in version 2.7.5. When trying to delete a dataset, the confirmation screen ask…
-
Created date columnsCreated date columns. They converted to alphanumeric. When I try to perform a compare date/time o…
-
Datasets not refreshing automaticallyHi, We built an integrated set of schedules and workflows that allows data from existent datasets t…
-
Does Aperture have the "treat leading zeros as alphanumeric" option that Pandora hadOne a a global setting that instructed Pandora to treat any input field with leading zeros as alph…
-
Select first three records in each clusterHi After running a Find Duplicates step at individual level I can see that we have many contact nam…
-
Function for similar charactersHello, I would like to create a function that will show as "false" when a column (E.g. co…
-
Filter for date rangeI would like to filter in a workflow for dates within the last 7 days from today. Right now the on…
-
Read from one space, write to anotherForgive me if this question is easy to answer; still getting up to speed after implementing Apertur…
-
How to copy dataset header to a row within the same dataset?Hello, I want to create an additional row on my dataset which would contain a copy of the header na…
-
My data consumers are unable to download as CSV.Within Role Permissions the Data Consumer Role is a tick next to 'Download data' and 'View Datasets…
-
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…
-
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…