Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Tell us your thoughts about the communityWe want to improve this community even more, which is why I'd love to set up some time with you to …
-
Tanj Jagpal: Head of Customer ExperienceI am the Head of Customer Experience at Experian Data Quality and work closely with our talented de…
-
Idea guidelines 💡We’re so excited to hear your ideas to make Aperture Data Studio even better. 📌 Before you get star…
-
Adrian Westlake: Product Design LeadHi, I've worked at EDQ for almost 5 years now and been responsible for the user experience in Data…
-
ℹ️ Importing your Datasets into Excel or Tableau using ODataYou can easily get your data from Data Studio into Excel or Tableau using OData. OData (odata.org) …
-
👩💻 The HTTP Request (REST API) stepThis post is to raise awareness of an additional workflow step, that is increasingly being used to …
-
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…
-
📣 Join us at our next User Group - 9th November 2023 📅I am pleased to confirm that our next User Group event for Aperture Data Studio users will take pla…
-
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…
-
♻ 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…
Categories
Popular tags
- Release notes 151
- Aperture Data Studio 132
- Find Duplicates 59
- Functions 56
- Data Studio 31
- Datasets 30
- Workflows 29
- REST API 26
- dmx 24
- feature demos 24
- tips and tricks 19
- Rules 18
- Community Challenge 15
- v2.8 14
- v2.12 14
- JDBC 14
- Extensions 13
- v2.11 13
- v2.5 12
- Notifications 11
- v2.14 11
- Transform 11
- Downloads 11
- v2.10 11
- Automations 10