Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
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 …
-
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,…
-
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…
-
New challenge ideasIf you have ideas for future challenges/puzzles/scenarios, please let us know as we're always …
-
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…
-
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…
-
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 te…
-
Analysing dates values placed in different rowsGood morning, I'm trying to build a logic that will compare two date values and returns the co…
-
Replacing values with a lookup column?Good afternoon, I'm trying to replace specific values (sample below) from a text field in a da…
-
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…
-
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…
-
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…
-
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…
-
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 …
-
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…
-
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…
-
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…
-
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 in…
-
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 c…
-
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…
-
Using workflow'(s parametersHi dear community, I'm using Aperture 2.8.8 verison My use case is calling a workflow through …
Categories
Popular tags
- Release notes 218
- Aperture Data Studio 165
- Functions 64
- Find Duplicates 59
- Workflows 46
- Datasets 45
- REST API 37
- Data Studio 33
- feature demos 26
- dmx 26
- JDBC 23
- tips and tricks 23
- Rules 19
- Automations 19
- validation 17
- Validate 16
- Transform 16
- Community Challenge 15
- v2.14 15
- Notifications 15
- datasource 15
- Downloads 14
- v2.12 14
- v2.8 14
- Extensions 14