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…
-
Help with Blocking Keys for Phone Numbers not generating resultsHi all, I'm trying to create two blocking keys for phone numbers, one that works off the first 5 d…
-
How long can/should the "Analyze blocking keys" function take?Morning all, I'm getting up and running with the find duplicates feature and have created my own b…
-
Pushdown processing on Experian ADSHello, We are trying to improve our workflow using "Pushdown processing" so, p…
-
REST API : getting the result of a workflow in the REST api responseHi dear community, Would it be possible to get the workflow result in the RESt webservice call ?…
-
How do I find if there are any duplicates across 15 different columns?Hi, I'm looking for a quicker/easier way to compare data across 15 columns and let me know if any …
-
Error while connecting to Embedded Duplicate StoreHi, I am getting error as below when I am trying to connect to the Embedded Duplicate store in my …
-
Error attempting to delete match storeHi, In my project, we are using Experian Aperture Data Studio(2.10.10) to connect to a Remote Find…
-
Error message when trying to define settings of a external system tableHi, We have connected one of our systems with Aperture, the connection is sucessfull and I can se…
-
How do you set up a custom event to trigger when a cell value exceeds a set tolerance?Hi all, I have a workflow which is currently producing the below output: I'd like to set up an au…
-
Merging columnsHi there, I am trying to fix a problem with telephone and mobile columns, the numbers are mixed up …
-
Profiling multiple datasetIn the Latest version I see there is an option of using multiple datasets in Profile and use all co…
-
How to create an output file that is FB (fixed-length blocked)I can create an output file in MS SSIS that when it gets placed on the mainframe, it is record form…
-
How do you compare 2 columns to locate and filter out duplicates?Hi all, If I want the values in Column A & Column B to be identical, what step do I need to pu…
-
How to view entire columns data from each steps of workflow?I have transforms, Group, and Filter steps on my workflow. And I'm concatenating four columns to cr…
-
Aperture Data Studio and Find Duplicates Upgrade@Ian Hayden , we have issue with our upgrade on DEV, Find duplicates is not working. We need your …
-
How to auto updated datasets when definition changed?Hello, Is there a way to automatically change the dataset definition when the external …
-
Error while invoking stored procedure from Experian Aperture Data Studio using custom JDBC driverHi, I am using the Experian Aperture Data Studio (2.10.0.80) and have configured a custom JDBC Jar…
-
Aperture REST API calls as Datasets within ApertureData is available from Aperture via the REST API that is not available in Aperture. Full details of…
-
How to capture log errors into a table if error occurred during execution of workflow or Schedules?How to capture log errors into a table if error occurred during execution of workflow or Schedules
-
Counting repeated values in a ColumnGood afternoon, Looking for a function that counts the number of times a value appears in a colunm…
-
DR for Studio VM & Duplicate Store VMWe have 2 Azure VMs- one with Aperture Data Studio Version 2.10.0.80 and another with Find Duplica…
-
ℹ️ Importing your Datasets into Excel or Tableau using ODataYou can easily get your data from Data Studio into Excel or Tableau using OData. OData (odata.org) …
-
Export as fixed length?Hi, I want to export data that will be going to our mainframe. The data needs to be a fixed length …
-
Can workflows be accessed/edited in another space once shared?Hi all, I've published a workflow in 'Your Space' and have set it to be shared with other selected…
-
Can we create a Dropzone folder where we can use multiple files?Currently we can create One folder Per Dataset where I can use only one file to be uploaded. Can we…
-
Parameter as a list?Hi, is it possible to have a parameter use a list? So the same workflow gets run for a list from an…
-
Migration of workflows containing links to FunctionsHi I have created several Functions and included these in a Workflow which has been tested in our…
-
Email domain validationHi there, I don't seem to find the function that validates email domains, can someone help, please?
-
Aperture British Summer Time (BST)Hi, There may be a very simple answer to this question, but is there some way of getting our Apert…
-
Migrating WorkflowHello, Everyone, We are going to install the latest version of Experian Data Studio on our brand-ne…
-
Why this function is not working when using replace matches?Good afternoon, Could you please help me to undertand why the following function isn't returning t…
-
A function to identify and remove multiple spaces between wordsGood morning, I've build the following function to identify and remove multiple spaces between wor…
-
shutdown due to heartbeat?2023-04-13 08:57:06,646 INFO c.e.d.b.BatchService [Thread-0] Shutdown due to heartbeat timeout 202…
-
Evaluation of Address Validation with APIDoes anyone know if Experian ADS can handle our requirement below: Functional Requirements Stand…
-
Wrong column problemHi there, I have a lot of data that is correct but in the wrong column for example, phone numbers o…
-
Cleaning FunctionHi there, does anyone know a function to clean whitespaces but leave one space between names? The e…
-
Why do the dates not match in this function?Hi, We are trying to write a Function that checks to see if a valus is a date and, if so, formats …
-
Exportable Object Endpoint via REST API for Change Tracking and AuditAs part of our ongoing efforts to manage Aperture using Aperture, we would like to use the Aperture…
-
Notification filtersLet's say I have 100 workflows and would like to set up an automation to send me email when they ar…
-
ADS, not enough permissions for page.user is admin to the workspace. what could possibly be the reason for her not to see the dashboard …
-
Aperture Data Studio - Find Duplicate ServersHello Community, Our organization has recently decided to use ADS for Data Quality tool and we are …
-
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…
-
A Function with two parameters is not showing up in a workflowI created 2 parameter Re-usable function its working and showing results. When I try to use it in W…
-
Relationships in ApertureIn Pandora we have option/facility to see the relationships between datasets/tables. In Aperture do…
-
Keyword: Community - Data Management User Group Material 09th March 2023It was great to meet the Experian Aperture Team and fellow users last week. Just wondering if and w…
-
Changing the External Source underlying the data setHi, We have developed several workflows using several data sets that are sourced from a particular …
-
Find Duplicate is showing empty records along with input recordsWe are using remote duplicate store. Whenever we run the workflow, the Find Duplicate step's result…
-
What is the Aperture Data Studio equivalent of TABLE LOOKUP in VALIDATE in Pandora ?We are migrating DQR's from Pandora to Aperture Data Studio. Pandora has TABLE LOOKUP functionality…
-
Aperture Data Studio update – March ‘23What’s happening? Aperture Data Studio has been updated to v2.10. This latest version includes new…
-
Number of columns in a dataset or a viewHello, How do we know the number of columns in a dataset (or a view) when we are in a workflow ? …