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
-
📽 📺 Achieve more with your data - videosOn the Data Studio homepage there is a widget named 'Achieve more with your data' that gives access…
-
Drop zone configuration in server.propertiesHi Team, Can we configure customize datadropzone folder at different shared location same as export…
-
Finding database / table attributesHi, Is there a way of creating an output of all the fields and attributes of a table / database. I …
-
finding previous day recordHi, I have a file of daily transactions where I find details of the latest record using Max date. H…
-
Calculating the difference between values on separate daysHi, I have created a grouped output which counts the number of loans per day as below. How do I cal…
-
Connecting to D365 with OAuthCan someone tell me what the settings are for the below when accessing D365 Authentication paramete…
-
Migrating Aperture Studio from one VM to anotherHi, We are trying to migrate Aperture studio installation from 1 virtual machine to another. Could …
-
How to promote from dev to prod environments when using different external systemsProblem: I’ve recently been working with a client who had used their Data Studio development enviro…
-
We need your feedback on Find DuplicatesHi all, We are evaluating the paths to a better Find Duplicates rule building experience. We unders…
-
Replacing the string value with Null if the end of the string matches with the LOVI have company names in a field I want to replace the end of the company name with Null if the name…
-
Relationship Discovery by using Find Duplicates Step in Aperture Data StudioWe tried to find the join candidates across tables and databases by using the profiling metadata in…
-
New Experian Data Quality RoadmapI am delighted to announce that the interactive version of Experian Data Quality's product roadmap …
-
REST API: get dataset list and their informationHello, We are looking to identify all datasets (of all spaces) that are in autorefresh. When we use…
-
Does Aperture have "rank()" function and how it works?Hi, is there similar function for Aperture? For example case
-
Manual review of Find duplicates clustersUsing a similar approach to that covered in an earlier post we demonstrate a method for manually re…
-
Snapshot build taking nearly an hourHi - I have a table of approx 25m rows looking up to 2 other tables to retrieve 2 values. I then ha…
-
Find duplicates functionality, duplicate matching and duplicate record resolution.Hi community members We're looking for customers and external evaluators of Aperture Data Studio th…
-
Dynamic Naming of Output FileHi, Is it possible to have a dynamic text element of the naming of an output file. I understand th…
-
Error with resuable workflow step in new workflowHi, I have created a workflow that produces an output and has been made reuseable. This workflow i…
-
ODBC: connection failledHello, We are facing some issues when we try to apply ODBC procedure (https://docs.experianapertur…
-
Dynamic DataSet NamingHi, We are trying to use Aperture V2 as part of the ETL workflow. We need to pick the data set from…
-
Does Aperture has the feature of Fuzzy Matching on Name/Company Name?We do have company names but it is maintained in different system in a different way. in One system…
-
Document Data Lineage in my Aperture installationI have recently joined a company using Aperture to manage their data quality. They have set up seve…
-
Error when running workflowWhen running a workflow I get the error message - One or more workflow steps are invalid - but no i…
-
How to Capture Trend of the DQ ScoresI have rules created and I have scheduled the rules to run on every weekend. Now how can I capture …
-
Transform to DecimalAperture 2.3.075 I'm struggling to find a basic and simple function to preserve decimal places when…
-
Importing and Exporting WorkflowsOne of the very first things that you will probably wonder, is just how portable are my workflows t…
-
Length of the maximum number of columns?I'm trying to import database table data into Aperture, but I'm having a problem with the length of…
-
Do we need license for the Data ConsumerWe have many Business users and want to give them only read access to the reports so we just want t…
-
How to get distinct value from a columnex I have company value in a table with contact details one company has multiple contact and now I …
-
Converting dates with ranging centuriesI have been unable to find a solution with an issue I am having converting dates in the format dd/m…
-
Data dropzone - additional columnsHi! I'm involved in a piece of work at the moment where we're using Aperture to map data in prepara…
-
Join after a filterHello, In Aperture 2.2.6.118 , when we use a join function just after a filter , we get error messa…
-
Creating backups of Aperture Data StudioI couldn't find much information in the documentation on how to create automatic daily backups for …
-
ℹ️ Removing Exact Duplicates / Exact MatchesA common thing users want to do with Data Studio is remove rows with (exact) duplicate values in se…
-
How to assign a variable value to a new column created in TransformI am creating a new column (X) in Transform and I want to assign the value I created in the previou…
-
Create our own Elements for Find Duplicates StepHi Team, I'd like to ask some questions about Find Duplicates Step. Is this step only for CONTACT …
-
How to assign a variable value to a column valueI want to assign the value of a column to my Workflow Parameter value. Ex. I have list of the colum…
-
Match RecordsGood Day, I have two datasets can I match them and get the records that matches either by company n…
-
Can I integrate Aperture with CollibraIs it possible to Integrate Aperture to Collibra? And then showcase the Rules created in the Apertu…
-
Can I Consume API in Aperture?How can I consume API in Aperture or how can I read/parse XML or JASON in Aperture
-
Scheduling workflows using the Data Studio REST API in version 2In v2.0 of Data Studio, the REST API has changed from v1, so this original post has been updated fo…
-
IF then ELSE LogicCan I write IF (Some Condition)THEN (Valid) Else (Invalid) Logic in Aperture? So That in the Output…
-
Questions about Data Tagging and Profiling in Aperture Data StudioHi team, Is it possible to tag and profile multiple tables at the same time in Aperture Data Studio…
-
Parameters for Source Step in Aperture Data Studio WorkflowHi Team, We want to use the API to run a workflow iteratively using different source datasets (we …
-
Has anybody used Aperture to anonomise/create synthetic data?I have a requirement to create anonymised/synthetic data My initial thought, for the name, would be…
-
Experian Address Validation Results LimitWe are trying to integrate Experian Address validation REST API into our system. It looks like the …
-
Searching for metadata in the UI (e.g from datasets view or others)Hi, I'm working on a data discovery project that needs to identify the best sources of critical dat…
-
How do we expand on the provided base blocking keys and rule sets on Aperture Data Studio?Hi team I am asking this question on behalf of one of our Credit Services team members. They are lo…
-
Explore option on Report ObjectHi, Am using a report object for dashboard and the explorer is not showing to be able to filter