Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Remove columns if emptyHi! Is there a way to remove the columns which do not contain any data in a workflow step? I would …
-
Retrieving Datasets from an external system using APIGood morning, We are currently on the beginnings of a project where we need to retrieve data from …
-
Error Encountered While Executing WorkflowI am attempting to manually execute a recently created workflow, but I am encountering an error. Th…
-
Input source filename as export filenameHi All! Could you please let me know how can I automatically add the input source filename to the e…
-
How is true / false field stored in Aperture?Note that the data below is business data and not PII. Issue: When I import the CSV file created in…
-
Aperture link to Googlesheet thru BigQueryI am in Aperture Version 2.8.8.27 I am trying to get connected to Googlesheet thru BigQuery. BigQ…
-
Want to pass certain input from API to the workflowi am trying to call an API from an external website my agenda is to pass some IDs that will be take…
-
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…
Categories
Popular tags
- Release notes 169
- Aperture Data Studio 146
- Functions 61
- Find Duplicates 59
- Workflows 35
- Datasets 34
- Data Studio 32
- REST API 31
- dmx 26
- feature demos 26
- tips and tricks 19
- Rules 18
- v2.14 15
- JDBC 15
- Community Challenge 15
- v2.8 14
- v2.12 14
- Extensions 14
- Automations 13
- v2.11 13
- Downloads 13
- Notifications 12
- Transform 12
- datasource 12
- v2.5 12