Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
📑 API paging with the Autonomous REST ConnectorIn this article I want to share a few approaches to configuring paging when accessing REST APIs usi…
-
PowerBI Automated RefreshWe know how to schedule workflows to run automatically. However, once the subsequent snapshots have…
-
SalesForce refresh failed to process query: INVALID_FIELDWe have scheduled refresh Jobs to refresh the Tables on daily basis. The Wfs are getting the status…
-
♻ Reusable workflow example – calculate word frequencyToday I’d like to share with you a reusable workflow that I built a little while ago not only as a …
-
ODATA: filtering the access to a datasetHello dear community, Our use case is as follow: We will have a big dataset and we would like to ge…
-
Internal errorHi there community, I am getting this error when trying to edit some workflows. I schedule some wor…
-
Handling data from Experian Aperture Data Studio jobsWe are getting error in the execution of Experian scheduled jobs as "There is not enough spac…
-
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 …
Categories
- All categories
- 17 Get started
- 471 Get involved
- 13 Support
- 269 Resources
- 3 Events
- Upcoming events
- 3 Event recaps
- 18 Ideas and roadmap
- 218 Community categories
Popular tags
- Release notes 139
- Aperture Data Studio 131
- Find Duplicates 59
- Functions 55
- Data Studio 31
- Workflows 28
- Datasets 27
- dmx 24
- REST API 22
- feature demos 22
- tips and tricks 19
- Rules 18
- v2.12 14
- Community Challenge 14
- v2.8 14
- v2.11 13
- Extensions 13
- v2.5 12
- Transform 11
- v2.10 11
- Address Validation 10
- Automations 10
- Dashboards & Charts 10
- blocking keys 10
- validation 10