Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Batch deleted after inserting records from Aperture to DatabricksHi Team, I am trying to insert the records from Aperture to Datbricks through JDBC driver and as p…
-
2Issue List – Status change event-based triggeringWhat problem are you facing? Need for an Issue List – Status change event-based triggering, to fi…
-
How to handle a table with more than 500 columns using 'rows to columns' object?Right now, 'rows to columns' object retrieves only 100 rows.
-
OData timeout settings?Hi, We've got a dataset we're trying to pull into Power BI via OData connection - with no…
-
3Calling stored procedures with workflow parametersWhat problem are you facing? I have a daily process that triggers a stored procedure. This stored …
-
How to invoke a stored procedureI wanted to execute a stored procedure from the workflow as its first activity. My credential has t…
-
Set Space & Dashboard as a default?Is it possible or has it been discussed about having the option to specify a Space and Dashboard as…
-
Union source informationHi, I am performing a union step of 5 sources. I hope its not a dumb question but I cant seem to fi…
-
2Exploring data - send to snapshotWhen exploring data, there is an option to download data. When performing analysis, it would be hel…
-
Connecting to a SAP HANA database using Data StudioFrom the Data Studio v1.6.1 release onwards, we've made it easier to connect to a SAP HANA dat…
-
No error message although dataset has been only partly uploaded due to timeout error of the endpointHi, I've created a custom model for Autonomous REST API by using Progress DataDirect and uploa…
-
How to load data from S3 using instance profile?We have hosted Aperture data Studio in a EC2 instance and now we want to load data from other exter…
-
Add a delay in automation between when a trigger is triggered and when the action is carried out.Hi, I currently have a number of schedules and automations running in order to run some sequential…
-
External System - Connecting to Oracle with TNS hostnameHi all, Is it possible to connect an Oracle database to Aperture without a hostname? We would like…
-
How to Implement Uniqueness & Referential Integrity Checks in Aperture Data StudioHi everyone, Happy New Year! 🎉 I wanted to share a quick tip that came up in a recent discussion a…
-
SSL Server Certificate IssueHi There, We have renewed the Server Certificate and need to add the same to Aperture Data Studio. …
-
ssl cert update process.has the process changed to update ssl cert on newer version? previously i used to do this, and …
-
Map list: Transform every item in a listWhat it does: Applies a transformation function to each item in the list and returns a new list wit…
-
Map path: Targeted transformation in JSON documentsIf you’re working with structured JSON data, Map path is your go-to Higher Order Function for apply…
-
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…
Categories
Popular tags
- Release notes 226
- Aperture Data Studio 166
- Functions 64
- Find Duplicates 59
- Datasets 47
- Workflows 46
- REST API 37
- Data Studio 33
- feature demos 26
- dmx 26
- JDBC 24
- tips and tricks 23
- Rules 19
- Automations 19
- validation 18
- Validate 17
- Transform 16
- Community Challenge 15
- Notifications 15
- v2.14 15
- datasource 15
- Downloads 14
- v2.12 14
- v2.8 14
- Extensions 14