Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Changing Data Studio's default Language and Region settingI recently needed to change the default Language and Region setting used by Data Studio when adding…
-
Eliminate rows with null values?I'm in the process of generating a dataset from a snapshot, and I'm interested in recommendations f…
-
New challenge ideasIf you have ideas for future challenges/puzzles/scenarios, please let us know as we're always looki…
-
Is there a Zip code validation Regex code library?Hi All, We need to check and validate the Postal codes in our database for all the countries and I …
-
Datasets - view typesHi, is there a way to see what datasets were imported as flat files or as delimited? And for the fl…
-
autoColumnMapping function in Workflow apiHi, Have you consider having a flag in your api to execute Workflows to use the auto Mapping column…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
Categories
Popular tags
- Release notes 190
- Aperture Data Studio 153
- Functions 61
- Find Duplicates 59
- Datasets 40
- Workflows 38
- REST API 35
- Data Studio 33
- feature demos 26
- dmx 26
- tips and tricks 21
- Rules 18
- JDBC 17
- v2.14 15
- Community Challenge 15
- v2.12 14
- datasource 14
- Downloads 14
- Extensions 14
- Automations 14
- v2.8 14
- Transform 13
- v2.11 13
- v2.5 12
- export 12