Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Adrian Westlake: Product Design LeadHi, I've worked at EDQ for almost 5 years now and been responsible for the user experience in Data…
-
Harmonizing of addressesHi there, I would like to understand better about the harmonizing of addresses. If I choose the bes…
-
Documenting what data is available in Data Studio (to users who don't have access)A question that cropped up earlier today was: 'how can we avoid different users connecting to the s…
-
Upgrade Issue, Aperture data studio , Find Duplicates latest versionsHi Ian, Looks like after the recent upgrade we have an issue that experianmatch path got changed t…
-
Matching Results - Find DuplicatesHi there, Any idea why in the matching results the big clusters are coming with different cluster i…
-
Low Disk Space issue.Hi, We have the disk space issue once more for our data drive. We changed the index expiry setting…
-
-
Standardise Country 🌎Standardise Country The function uses reference data (contained within the .dmxd file) to standardi…
-
Equals Function - does it ignore characters?I am using the 'equals' function to compare two fields, looking for differences. However, it seems …
-
UPRN ValidationI was using the address validation function to validate StreetTown and PostTown against the UPRN on…
-
Harmonizing rulesHi there, Can anyone help with the harmonizing process? I have a huge list with names, phone, email…
-
📙 revAlation (with ApertureData Studio + Alation demo 💻)Last week a few of us from Experian (Fran, Nicole, @Job, @Josh Boxer, @Doug & I) attended RevAl…
-
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…
Categories
Popular tags
- Release notes 182
- Aperture Data Studio 149
- Functions 61
- Find Duplicates 59
- Workflows 36
- Datasets 36
- REST API 34
- 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
- v2.11 13
- Downloads 13
- datasource 12
- Transform 12
- Notifications 12
- v2.5 12