Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Refresh a dataset from REST WSHi dear community, Is it possible to refresh a dataset data through REST web service ? I know that…
-
Source Table Name on workflow coming as "SQL Query"Hello, One of my workflow datasets is SQL query and when I pull metadata like database nam…
-
Error while running workflowHello, I am trying to run the newly created workflow manually and it is giving me an error. It says…
-
Harmonize Duplicate based on recent dataIs there a way to select only the recent record while doing the data merging and selecting the gold…
-
Is there a scramble function?Hi, Is there a scramble function (much like there was in Pandora), as that feature was great for hi…
-
How to optimise Validation, Filter, and Take Snapshot StepsHey folks, Can anyone help me with optimising performance on Validation, Filter, and Take Snapshot …
-
Refreshing Datasets Error MessageHi, I recently updated the credentials for an external system, and when refreshing some of the tabl…
-
Data Quality reporting over timeWe have a set up here at Speedy where we have data quality split across multiple spaces. We pull al…
-
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 ? I…
-
Google Forms as a sourceHello, I hope you're fine :o) I'm wondering if Aperture could take Google Forms as an input source…
-
What does error 4002: Output column does not appear in input meanI can't see why this error is being produced. the grouping step has all the data required to create…
-
Workflow triggered via datadropzone - Dynamic Source in WorkflowI see that a source in workflow can be defined as dynamic and we can pass the source name when runn…
-
Workflow inside workflowHey community, I am trying to get one workflow to run 2 workflows inside itself. In one workflow th…
-
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…
Categories
Popular tags
- Release notes 182
- Aperture Data Studio 149
- Functions 61
- Find Duplicates 59
- Workflows 36
- Datasets 36
- REST API 34
- Data Studio 32
- feature demos 26
- dmx 26
- tips and tricks 19
- Rules 18
- JDBC 17
- v2.14 15
- Community Challenge 15
- v2.8 14
- Automations 14
- Extensions 14
- v2.12 14
- v2.11 13
- Downloads 13
- datasource 12
- Transform 12
- Notifications 12
- v2.5 12