Stuck with creating a Workflow or simply curious how Aperture Data Studio can help you? You’re in the right place! To get the most relevant answers, remember to tag your post with the version number (e.g. v1 or v2). Didn’t find what you’re looking for? Check out user documentation.
General discussion
Discussion List
-
Email notification of new Aperture Data Studio releasesIn order to get notified of new Aperture Data Studio releases, you can follow the Downloads and Rel…
-
Aperture Data Studio Hosted and Managed Service Maintenance ScheduleFor our customers on the Aperture Data Studio Hosted and Managed Service: The maintenance schedule …
-
Exact match, fuzzy match and de-duplication with Find DuplicatesHi everyone, I'm starting a series of articles all about matching and linking records to find dupli…
-
Introducing the new Functions Library - fast track your time to value with Data Studio!The Functions Library is a collection of free, reusable content for you to instantly download and u…
-
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…
-
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…
-
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?
-
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…
-
Aperture REST API calls as Datasets within ApertureData is available from Aperture via the REST API that is not available in Aperture. Full details of…
-
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…
-
Workflow triggered via datadropzone - Dynamic Source in WorkflowI see that a source in workflow can be defined as dynamic and we can pass the source name when runn…
-
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…