Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Accessing Azure KeyVaultI have stored my Azure SQL's connection string as a secret in the Azure KeyVault. I wanted to acces…
-
Set default to always ignore NULLSHi, I am doing sever DQ checks on a single field within a validation step. On each of these checks…
-
Split a value into multiple rowsHi I have full addresses split by ; that I want to split out into new rows ready for the Address Va…
-
Has anyone else had issues connecting to an AWS RDS server? And if so how did you manage to connect?We are having issues connecting to an RDS server, the port is definitely open and the username/pass…
-
Get the 6 month Older Date from TodayIs there any easy way to get the date which is 6 months older than today?
-
Future Date Check 📅 (Dynamic)Summary This package contains 2x rules: “Is a future date” and “Not a future date” (compared to cur…
-
Sending email to stakeholders through Data Studio DynamicallyHi, We want to send the email notification to the users who are creating issues example creating d…
-
Convert Epoch Date/Time to Standard Date/Time ⌚Convert Epoch Date/Time to Standard Date/Time ⌚ This function was inspired by this post and created…
-
Please make Rows per Page configurableThis is a suggestion for improvement. Please make Rows per Page configurable per user. I prefer to…
-
We are due for license renewal for address validation API. Whom do I contact?We are due for license renewal for address validation API. Whom do I contact? I don't have account…
-
📣 Join us in person at our next UKI Data Management User Group I 9th March 2023 📅I am pleased to confirm that our next UK Data Management User Group will take place on Thursday 9 M…
-
Functions - suggested product improvementHi, When working with a list of functions, every time I edit/publish/share one it returns me to the…
-
Uniqueness and/or Completeness as a validation ruleHi, I know we have the profile step and the validation step in a workflow, but how can I create a v…
-
Copying transformationsJosh made some comment in the User Group the other day that it was now possible to copy and paste l…
-
Lookup step returning unexpected valuesHello. I am currently using version 2.8.8.27. I've discovered recently that in one of my workflows,…
-
Inner Join WorkflowWe use the inner join workflow to look at the matching unique ID between 2 sources. This is used fo…
-
Connecting to hosted Dynamics 365 with OAuth2Data Studio’s Dynamics 365 connector can be used to read or write data from Microsoft Dynamics 365 …
-
Dataset Update through APIWe have a requirement to Update the Dataset with API. Currently we are manuall placing the .csv fil…
-
is it ok to delete the default environmentfor a cleaner login experience for users, if we are never going to use the default environment, is …
-
External Rest API'sAfternoon, I'm new to Aperture and wanting to know if it possible to bring data into Aperture thou…
-
Adding views to a spaceWould it be possible to make an enhancement to permit the searching for a particular view when incl…
-
Admin History ViewIs there a way as an admin to view a history of files uploaded and deleted to Aperture, the user th…
-
Consumer users accessing/updating issuesHi - Does anyone have any knowledge of consumer users accessing issues? I've set up the consumer us…
-
Thresholds in validation stepHi, Sorry me again! I was just wondering if the thresholds, which are set at rule group level can b…
-
API to Get Scheduled Jobs InformationThere is One API to get the information about the scheduled Datasets. But in that we have to Pass t…
-
Function for duplicate SSN'sHello, My first post in the community so please bear with me. Trying to create a function to catch…
-
Converting the Numbers in the stats to the Nordic Number FormatWe have this chart, where in the Vertical we have some numbers which are in format N,NNN we want to…
-
It is possible to use the SharePoint Online list as data source?We have a Sharepoint form with information. The form contains some columns and rows. Is it possible…
-
Duplicate Triggering of workflow with datadropzone2 questions please: When a file is dropped in the datadropzone, it gets removed almost instantly. S…
-
Java pid hprof crash files.Facing the issue in our dev server for Aperture Data Studio and Find Duplicates. In log I have foun…
-
ℹ How to track DQ issues with Issue listsIssue lists allow you to capture problematic records, assign them to stakeholders and collaborate o…
-
Issues Lists - notificationsHi everyone, I'm looking at setting up some issues lists for the first time, and I have a question …
-
🎞️ A short video demonstation on using the Quick Actions bar, shortcuts and moreSince Aperture Data Studio 2.8.0 users have been able to use the Quick Actions bar to access freque…
-
Replace Matches function returning custom columns?Hello. I have a large table in which I would like to replace certain values with a lookup from a st…
-
Test if field contains only white spaceHi, I am still new to ADS. I have fields that contain just white spaces (1-3 spaces in a row [&quo…
-
Rename Widget without Renaming the View/ChartHi, is there a way to rename widgets in a dashboard without changing the name of the view/chart/dat…
-
Java Update - Vulnerability detected on our Experian Dev/Prod ServerThis version has been detected as vulnerable by - OCPU-2022-JUL: Oracle Java Critical Patch Update …
-
Join us Online for our next Data Management User Group | 15 September 22 !I am pleased to confirm that our next UK Data Management User Group will take place on Thursday 15 …
-
Can we add a hyperlink to the e-mail notification?Hi! Is it possible to add a hyperlink to the e-mail notification? It would be a nice feature to be …
-
Is it possible to have dtill down in Charts /TrendI have trend where I am showing some stats based on the month , I have also information available b…
-
Row to Column after validate stepIf I am using row to column step after the validate step then using Sum to remove the null and get …
-
Adding datasets from database viewsHi, I'm currently uploading datasets in Aperture from a SQL database, a total of 15 tables were ing…
-
File name as a parameter in exportHello, I hope you're all fine :o) In a workflow, we use a dataset (which has as source a file), l…
-
Using Columns-to-Rows before a join.Hello. I'm using version 2.8.8.27 and have encountered the following phenomenon. When using the Col…
-
How to identify blocking keys for Find DuplicatesBlocking keys identifies records that are similar, creating blocks or potential groups of matches. …
-
Aperture Data Studio backups@Henry Simms , what would be the equivalent link to this according to current version. https://www…
-
how to find Dataset & External Systems dependencyI tried with API to get the list where I can find the list of the Datasets along with the external …
-
How to delete Duplicate external systems and tag dataset with the actual oneHow to delete Duplicate external systems in a space and then tag datasets that belongs to that exte…
-
Snowflake Issues with Dataset CreationWe have deployed the proper snowflake drivers and have successfully connected to a hosted warehouse…
-
Dynamic SQL statementI've set up a re-usable workflow. I'm trying to set up a dynamic SQL statement to execute in the pr…
Categories
- All categories
- 17 Get started
- 484 Get involved
- 18 Support
- 253 Resources
- 3 Events
- Upcoming events
- 3 Event recaps
- 18 Ideas and roadmap
- 97 Community categories
Popular tags
- Release notes 139
- Aperture Data Studio 131
- Find Duplicates 59
- Functions 55
- Data Studio 31
- Workflows 29
- Datasets 27
- dmx 24
- REST API 22
- feature demos 22
- tips and tricks 19
- Rules 18
- v2.12 14
- v2.8 14
- Community Challenge 14
- v2.11 13
- Extensions 13
- v2.5 12
- Notifications 11
- Transform 11
- v2.10 11
- Address Validation 10
- Automations 10
- Dashboards & Charts 10
- blocking keys 10