Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Filter list: Keep only what mattersWhat it does: Returns a new list containing only the items that meet the condition defined by the o…
-
Any match: Find just one match in a listWhat it does: Checks whether at least one item in a list satisfies a condition defined by a Boolean…
-
All match: Validate every item in a listIn this post, we will take a closer look at All match, one of the higher order functions now availa…
-
Unlock powerful list and record logic with the higher order functions (part of List transformation)In this series, we will explore the new set of Higher Order Functions (introduced in Aperture Data …
-
Gen AI in Aperture Data StudioAperture Data Studio has functionality that uses several different machine learning and artificial …
-
Enabling workflow report to data consumerHi, I have a report created in a workflow. I have marked to expose it to data consumer roles. How t…
-
6Drill-through for Comparison stepHi, I recently ran a workflow using the compare step to check differences between 2 systems. I want…
-
Best Practices for TransformationsJust wanted to see what the general approach is (best practice) for applying transformations in cer…
-
-
2Include system object tags in solution package / deploymentWhat problem are you facing? When creating / deploying a solution, system object tags set on datas…
-
Suggestion: Auto-Save rules in a validation stepHi, I have come across something rather infuriating this afternoon whilst creating a number of va…
-
1Unique download URL for new releaseshi team! thanks for the good work in posting release notes and urls to download. Can I please ask t…
-
2Add object tags for chartsWhat problem are you facing? Unable to add an object tag to a chart. What impact does this proble…
-
A solution design for validating multiple mixed file schemasWe've recently been working on a solution to the following ask: A user has hundreds of data fi…
-
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 - …
-
6Trash 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…
Categories
Popular tags
- Release notes 221
- Aperture Data Studio 166
- Functions 64
- Find Duplicates 59
- Datasets 46
- Workflows 46
- REST API 37
- Data Studio 33
- feature demos 26
- dmx 26
- JDBC 23
- tips and tricks 23
- Rules 19
- Automations 19
- Validate 17
- validation 17
- Transform 16
- Community Challenge 15
- Notifications 15
- v2.14 15
- datasource 15
- Downloads 14
- v3.1 14
- Extensions 14
- v2.8 14