Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Copy of FiServ Files uploaded into DA & use of the Metro2 ParserDoes anyone use Data Arc with a copy of a FiServ Metro2 File? We are setting this up as net new an…
-
Azure Cosmos DB ConnectionHello, We thinking to connect the cosmos db using a JDBC connection in our ADS. However, …
-
Aperture Find Duplicates Match Status and Cluster ID ColumnsHi As my workflows grow and I'm introducing more Find Duplicate steps I've realised I need to start…
-
Connecting Synapse to ExperianSo I am trying to connect Experian to Azure Synapse to get DQ result. So I have tried using the JDB…
-
Stored Procedure invoked from PostSQL of Export step is not processing all recordshi, In my workflow, I am connecting to SQL server 2012 using Custom JDBC jar (Microsoft JDBC Jar 12…
-
Date formats...Earlier today I received the below email from a customer which I wanted to post on here in case the…
-
Why would a snap shot drop all data in some columns when run as part of a workflow?I have a workflow that acts as shell for several workflows that run in sequence (first cleaning dat…
-
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…
Categories
Popular tags
- Release notes 185
- Aperture Data Studio 149
- Functions 61
- Find Duplicates 59
- Workflows 36
- Datasets 36
- REST API 35
- 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
- Downloads 14
- v2.11 13
- datasource 12
- Transform 12
- Notifications 12
- v2.5 12