Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Make "max number of columns" a variableHi All, Is there any way to make the max number of columns value a variable? I do not always know p…
-
Find Duplicate Step's result is not showing upIn the Find Duplicate Step, after configuring input data set, duplicate store as Temporary Store an…
-
Replace functionHi there, I am trying to make a function to replace some values with null. I did it with on value b…
-
running multiple workflows through rest API : UNKNOWN: 2046: Session is invalid or has expireHello dear team, when we run 4 workflows using a rest api (via Talend job), we are getting error m…
-
How I got started with Data StudioAssuming Data Studio is set up and your user account has been created, “Your space” is your persona…
-
Regular exression match not foundHi All! I would like to create a Regular Expression match check for the whole number 3 in a string.…
-
Unique ID for Validation RulesHi, Is there a way of exposing the unique ID for a validation rule, either via the API or another m…
-
Joining to Validate Function, but keep Validation FormattingHi, I have a Validation step, it works perfectly. However, I want to append an additional column vi…
-
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…
-
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…
-
Convert Epoch Date/Time to Standard Date/Time ⌚Convert Epoch Date/Time to Standard Date/Time ⌚ This function was inspired by this post and create…
-
Please make Rows per Page configurableThis is a suggestion for improvement. Please make Rows per Page configurable per user. I prefer to…
-
📣 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…
-
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…
-
Lookup step returning unexpected valuesHello. I am currently using version 2.8.8.27. I've discovered recently that in one of my workf…
-
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…
-
Consumer users accessing/updating issuesHi - Does anyone have any knowledge of consumer users accessing issues? I've set up the consum…
-
Thresholds in validation stepHi, Sorry me again! I was just wondering if the thresholds, which are set at rule group level can b…
-
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…
-
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…
-
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…
-
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 …
-
Issues Lists - notificationsHi everyone, I'm looking at setting up some issues lists for the first time, and I have a ques…
-
🎞️ 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…
-
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 wer…
-
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 fil…
-
Using Columns-to-Rows before a join.Hello. I'm using version 2.8.8.27 and have encountered the following phenomenon. When using th…
-
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…
-
Dynamic SQL statementI've set up a re-usable workflow. I'm trying to set up a dynamic SQL statement to execute…
-
Can I create Interactivity Snapshot when unioning multiple Profiles from different datasetsHi, I am new to ADS. I want to make a dashboard a single widget, the widget would be the profile …
-
Connecting to a database with a different schemaIs there a setting that needs including to be able to pull data from a different schema from the sa…
-
Quick Actions menuSince v2.8 Aperture Data Studio has had a command palette that makes shortcuts and access to freque…
-
Validate Email Domain. Accuracy?Hi, I have the validate email address (domain) function up and running, but I am not sure about the…
-
SSL certificate about to expire. need to apply the new one.Data Quality user documentation | Security (experianaperture.io) This documentation for applying SS…
-
Version 2.7.5 Delete dataset bugWe identified a bug in version 2.7.5. When trying to delete a dataset, the confirmation screen ask…
Categories
Popular tags
- Release notes 224
- 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 17
- Validate 17
- Transform 16
- Community Challenge 15
- Notifications 15
- v2.14 15
- datasource 15
- Downloads 14
- v2.12 14
- v2.8 14
- Extensions 14