Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Calculate the distance between two sets of co-ordinates 🌍️ Summary Returns the approximate distance in kilometres between a pair of geographical co-ordinates.…
-
Group Data by YearHello, in one of my datasets I have a date column. Is there a way I can group this and count by Ye…
-
Copy cells and Download data blockedHello, I am an admin at my company using Aprture Data studio. I created profiling on some tables, h…
-
'Time period for all events to occur' box within automationsHi, Is anyone able to explain what the : ''Time period for all events to occur' doe…
-
Custom email notifications to include failing validation rulesHi, I am wanting to set up email notification that fire when a data quality workflow validation st…
-
"Create and Insert" selection is not visible in Workflow Export stepHi, We have version 3.1.12 but "Create and Insert" selection is not visible in Workflow E…
-
Make Your Data Pop: Visual Styling in Aperture Data StudioAllow your data to speak for itself - Aperture Data Studio offers powerful ways to make your result…
-
Why do I still see a warning even after the license is refreshed successfully?Hi, I upgraded Experian Aperture Data Studio from 2.14.14 to 3.1.12 and Find duplicates from 3.12.1…
-
Possibility to configure workflow report download destination?Hi, Workflow report gives very good information about the details related to the workflow. Is it po…
-
Question on how to calculate a resultHello, I am trying to calculate a solution using Aperture Data Studio. I have a table (as shown on …
-
Cache, performance, and processesHi! We have just started using the Aperture Data Studio. We tried to profile a hefty table (2mil + …
-
Upgrading Experian Aperture Data Studio from v2 to v3Hi, We are planning to upgrade our Experian Aperture Data Studio from v2.14.14.40 to the latest v3 …
-
⚠️ licensing certificates issueFor any customers using cloud licensing it is possible Aperture Data Studio will not be able to cal…
-
5A default value for "automatically delete data after N days"What problem are you facing? Almost all the data loaded into my Data Studio instance has a mandate…
-
SSL certificate error connecting to SQL Server after applying entitlement CA certThis discussion was created from comments split from: ⚠️ licensing certificates issue
-
Validating Bank account detailsGood morning, We know that Aperture already has built-in functions to check the format of bank acco…
-
Pushdown Processing Advanced Function MappingEvening all, We're looking at implementing pushdown with Snowflake and have hit a couple of fu…
-
How to send a notification email to the assigned individuals for each issue in the issue list?"Hello All, I need send a notification email to the assigned individuals for each issue in the issue…
-
How to export dataset through API from Aperture Data studio?Hello All I want to export one dataset in Experian through API and save it as csv file in my one d…
-
3Add additional dataset source - dropzone namingHi, I really like the capability to have multiple dataset sources, I have used it numerous times - …
-
5Trash Bin?What problem are you facing? Deleting of batches often after a failed run. It's nerve racking…
-
4Sticky Notes attached to Workflow stepJust a thought… but it would be really nice if Sticky notes could be pinned to workflow steps (I al…
-
Automation - only writing to last batch to datasetHi, I have a multi-batch dataset (lets say DS1) that is configured for an external dropzone. When n…
-
2A way to "execute workflow with all batches in the Dataset" when a new batch triggers the executionWhat problem are you facing? A common setup in automated end-to-end automation in Data Studio is: …
-
ℹ How to track DQ issues with Issue listsIssue lists allow you to capture problematic records, assign them to stakeholders and collaborate o…
-
Pushdown Processing on a pivotHi, In testing Pushdown Processing today, I hit a couple of errors. The first is simple to workarou…
-
Power BI OData connections are significantly slowing down Aperture, how to configure to prevent?Hi, Our self-service users are using Odata connections to fetch data from Aperture DS to Power BI b…
-
External system drop zone stopped workingHi, The drop zones that I have set up for several subfolders for many files has stopped working, an…
-
Find Duplicates no connectingHi there, I am having problems making the duplicate stores connect to the server. I checked the ser…
-
9Administration Space containing info on all objectsGeorge_Stephen - December 11 "Please create a Administration Space that contains information o…
-
Search and replace of multiple values.Hi everyone!, I have a table with 2 columns, the first one is the string I should check inside a f…
-
Suggested approaches for manipulating JSON valuesMy data includes a column containing JSON values - I've made a dummy example below: Example …
-
Create a function that compares the date open to todays datehow would i create a function that compares the date open to today's date
-
Find Duplicates IssueHi there, I'm having this issue with the find duplicates step, can anyone help?
-
Schema-Flexible Configuration with JDBC (Apache Hive 6.0) External SystemWe've successfully configured an external system using Connection type: JDBC and DBMS: Apache …
-
How can I configure TLS for the Find Duplicates WorkbenchWhat are the steps to configure an SSL certificate for the Find Dupes Workbench site? I already hav…
-
1Improved Driver support for Teradata data warehouse platform.What problem are you facing? Improved Driver support for Teradata data warehouse platform. We curr…
-
Useful Function: Distance between two coordinatesRecently developed a function based on the Haversine Formula to generate the distance between two c…
-
Workflow option to Refresh Sources doesn't apply to Contains MatchHi, I have a validation step that performs a 'Contains Match' on a lookup table (I am che…
-
Data Governance Masterclass - 9th OctoberHi all, We’re excited to invite you to our upcoming in-person Data Governance Masterclass on Thurs…
-
Date column recognized as "alphanumeric" while profilingi have some date columns in my table (like below example). Just done profiling on those columns it …
-
Distinct count aggregationI am not sure how to apply distinct count as aggregation while do group by ? There is check box &q…
-
♻ 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 …
-
How to explore Workflow script (preview) functionalityRecently we upgraded to experian 3.1, and i would like to try Workflow Scripting (preview). But i u…
-
3Manually reviewing clusters of duplicate records (Stewardship)What problem are you facing? As a Find duplicates user I want to be able to manually evaluate and …
-
9Find Duplicates: handling of Gmail email modifiersWhat problem are you facing? The Email and Email_Local elements in Find Duplicates Standardization…
-
Word FrequencyEvery now and then a scenario crops up where it'd handy to know how often a given word occurs …
-
Address Elements, how does the Duplicate Store determine which element a field is?Hi all, Does anyone know where I can find some detailed documentation on how the duplicate store de…
-
Automation Email Trigger Works for Individuals, Not Distribution List(DL)Hi Aperture team, I’m currently using the Automation feature to trigger email notifications. Since …
-
4OAuth 2.0 authentication method with SnowflakeWhat problem are you facing? How can we connect to Snowflake external system with OAuth 2.0 authen…
Categories
Popular tags
- Release notes 217
- Aperture Data Studio 164
- Functions 64
- Find Duplicates 59
- Workflows 46
- Datasets 45
- REST API 37
- Data Studio 33
- dmx 26
- feature demos 26
- tips and tricks 23
- JDBC 23
- Rules 19
- Automations 19
- validation 17
- Transform 16
- Validate 16
- datasource 15
- Notifications 15
- v2.14 15
- Community Challenge 15
- v2.12 14
- Extensions 14
- Downloads 14
- v2.8 14