Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Aperture Data Studio CertificationIs there any Official Data Studio Certification?
-
Email notification of new Aperture Data Studio releasesIn order to get notified of new Aperture Data Studio releases, you can follow the Downloads and Rel…
-
API KeyHello, We use Aperture 2.8.8 version, we've noticed that in the uat env, we can create an API key …
-
Is it possible to export a file as an XML please?I have a set of data and would like to be able to export it as an XML. I have a solution that allo…
-
Grouping with TOTALS row?I have a grouping of data that I have an aggregation of (sum) for various data points (about 60 row…
-
Creating Solution- Selected all spacesWhy I am trying to create a solution all the spaces where I have access have been selected automati…
-
oData DriverHi I want to fill a Dataset on scheduled basis from an oData source, but no oData options are avail…
-
🛢️ Loading from OData using the Autonomous REST ConnectorThe Autonomous REST Connector JDBC driver packaged with Aperture allows you to load (and refresh) t…
-
Workflow is not in an executable state but no errors existHi DQ Community, I have a workflow that I can't run or publish because I get error messages telling…
-
Refresh dataset notificationHello dear community, my use case is: we refresh more that 200 dataset ( from SAP source) in the s…
-
Analysing dates values placed in different rowsGood morning, I'm trying to build a logic that will compare two date values and returns the compari…
-
Replacing values with a lookup column?Good afternoon, I'm trying to replace specific values (sample below) from a text field in a dataset…
-
Can I identify duplicate customer account numbers in a file?I have a significantly large file over 5 million records. I wanted to see if there is a way to dri…
-
Cosmos DB to Readable SQLHello, Has anyone yet used Cosmos db in Experian? We are trying to denormalize cosmos db …
-
What does this column duplicate:Action mean?The results on my duplicate step are coming with some empty gaps and when I checked it all the gaps…
-
Is there a way to filter/extract certain columns from the datasets?Hello, I'm trying to filter or separate a few columns from the datasets so, is there a w…
-
Autonomous REST connection SQL queryHow can I get a simple SQL running when everything is set up . the Autonomous REST connection is su…
-
📑 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…
-
Aperture REST API calls as Datasets within ApertureData is available from Aperture via the REST API that is not available in Aperture. Full details of…
-
Moved: Aperture REST API calls as Datasets within ApertureThis discussion has been moved.
-
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…