Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Why this function is not working when using replace matches?Good afternoon, Could you please help me to undertand why the following function isn't returni…
-
A function to identify and remove multiple spaces between wordsGood morning, I've build the following function to identify and remove multiple spaces between…
-
shutdown due to heartbeat?2023-04-13 08:57:06,646 INFO c.e.d.b.BatchService [Thread-0] Shutdown due to heartbeat timeout 202…
-
Wrong column problemHi there, I have a lot of data that is correct but in the wrong column for example, phone numbers o…
-
Cleaning FunctionHi there, does anyone know a function to clean whitespaces but leave one space between names? The e…
-
Notification filtersLet's say I have 100 workflows and would like to set up an automation to send me email when th…
-
ADS, not enough permissions for page.user is admin to the workspace. what could possibly be the reason for her not to see the dashboard …
-
TLSv1 and TLSv1.1 protocols disabled by default in Data StudioTowards the end of 2021, TLSv1 and TLSv1.1 protocols became disabled by default in Java 8, on which…
-
Find Duplicate is showing empty records along with input recordsWe are using remote duplicate store. Whenever we run the workflow, the Find Duplicate step's r…
-
Number of columns in a dataset or a viewHello, How do we know the number of columns in a dataset (or a view) when we are in a workflow ? …
-
Find Duplicate new feature compatibilityWe are using 2.9.6 ADS version in our prod serverand we have WFs to replace the existing duplicate …
-
Pivot grouping issue?Hi All, I have an issue with the pivot and I'm not sure how to solve this or what function to …
-
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…
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