Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Labelling rows based on GroupingIs there an easy way of labelling rows based on a grouping step? in my source data of roughly 25,00…
-
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 di…
-
Using workflow'(s parametersHi dear community, I'm using Aperture 2.8.8 verison My use case is calling a workflow through REST …
-
Profiling multiple datasetIn the Latest version I see there is an option of using multiple datasets in Profile and use all co…
-
Pushdown processing on Experian ADSHello, We are trying to improve our workflow using "Pushdown processing" so, pl…
-
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 bl…
-
Licensing for Aperture Data StudioThis article provides an overview of all things cloud licensing including pre-requisites, activatio…
-
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 o…
-
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 D…
-
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 see…
-
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 auto…
-
Merging columnsHi there, I am trying to fix a problem with telephone and mobile columns, the numbers are mixed up …
-
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 put…
-
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 t…
-
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 …
-
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…
-
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 Apertu…
-
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 th…
-
A function to identify and remove multiple spaces between wordsGood morning, I've build the following function to identify and remove multiple spaces between word…
-
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 Standar…
-
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 i…
-
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 ? …
-
Find Duplicate new feature compatibilityWe are using 2.9.6 ADS version in our prod serverand we have WFs to replace the existing duplicate …
-
Aperture Data Studio quarterly newsletter – March‘23We’ve recently updated Aperture Data Studio to the latest version, v2.10. You can view the interac…
Categories
Popular tags
- Release notes 162
- Aperture Data Studio 143
- Functions 60
- Find Duplicates 59
- Workflows 35
- Datasets 34
- Data Studio 32
- REST API 31
- feature demos 26
- dmx 25
- tips and tricks 19
- Rules 18
- Community Challenge 15
- v2.14 15
- JDBC 15
- v2.12 14
- v2.8 14
- Extensions 14
- v2.11 13
- Notifications 12
- Automations 12
- Transform 12
- datasource 12
- Downloads 12
- v2.5 12