Experian Data Quality Community
Learn, collaborate and solve problems with like-minded data quality enthusiasts.
Discussion List
-
Parameter as a list?Hi, is it possible to have a parameter use a list? So the same workflow gets run for a list from an…
-
Migration of workflows containing links to FunctionsHi I have created several Functions and included these in a Workflow which has been tested in our …
-
Email domain validationHi there, I don't seem to find the function that validates email domains, can someone help, please?
-
Aperture British Summer Time (BST)Hi, There may be a very simple answer to this question, but is there some way of getting our Apertu…
-
Migrating WorkflowHello, Everyone, We are going to install the latest version of Experian Data Studio on our brand-ne…
-
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 returning th…
-
A function to identify and remove multiple spaces between wordsGood morning, I've build the following function to identify and remove multiple spaces between word…
-
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…
-
Evaluation of Address Validation with APIDoes anyone know if Experian ADS can handle our requirement below: Functional Requirements Standar…
-
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…
-
Why do the dates not match in this function?Hi, We are trying to write a Function that checks to see if a valus is a date and, if so, formats i…
-
Exportable Object Endpoint via REST API for Change Tracking and AuditAs part of our ongoing efforts to manage Aperture using Aperture, we would like to use the Aperture…
-
Notification filtersLet's say I have 100 workflows and would like to set up an automation to send me email when they ar…
-
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 …
-
Aperture Data Studio - Find Duplicate ServersHello Community, Our organization has recently decided to use ADS for Data Quality tool and we are …
-
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…
-
A Function with two parameters is not showing up in a workflowI created 2 parameter Re-usable function its working and showing results. When I try to use it in W…
-
Relationships in ApertureIn Pandora we have option/facility to see the relationships between datasets/tables. In Aperture do…
-
Keyword: Community - Data Management User Group Material 09th March 2023It was great to meet the Experian Aperture Team and fellow users last week. Just wondering if and w…
-
Changing the External Source underlying the data setHi, We have developed several workflows using several data sets that are sourced from a particular …
-
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 result…
-
What is the Aperture Data Studio equivalent of TABLE LOOKUP in VALIDATE in Pandora ?We are migrating DQR's from Pandora to Aperture Data Studio. Pandora has TABLE LOOKUP functionality…
-
Aperture Data Studio update – March ‘23What’s happening? Aperture Data Studio has been updated to v2.10. This latest version includes new…
-
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 …
-
Aperture Data Studio quarterly newsletter – March‘23We’ve recently updated Aperture Data Studio to the latest version, v2.10. You can view the interac…
-
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 use t…
-
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…
-
Validation - order of rulesIs it possible to arrange the sort order of rules (possibly by manipulating the Order number within…
-
Find Duplicate Step's result is not showing upIn the Find Duplicate Step, after configuring input data set, duplicate store as Temporary Store an…
-
How to invoke a stored procedureI wanted to execute a stored procedure from the workflow as its first activity. My credential has t…
-
Replace functionHi there, I am trying to make a function to replace some values with null. I did it with on value b…
-
How to export workflow result to Snowflake tableHi, I have a scenario, where I want export workflow processed dataset to be exported/pushed to sno…
-
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…
-
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…
Categories
Popular tags
- Release notes 169
- Aperture Data Studio 146
- Functions 61
- Find Duplicates 59
- Workflows 35
- Datasets 34
- Data Studio 32
- REST API 31
- dmx 26
- feature demos 26
- tips and tricks 19
- Rules 18
- v2.14 15
- JDBC 15
- Community Challenge 15
- v2.8 14
- v2.12 14
- Extensions 14
- Automations 13
- v2.11 13
- Downloads 13
- Notifications 12
- Transform 12
- datasource 12
- v2.5 12