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
-
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
-
Single Customer View (SCV) user research interview invitationHi all, At Experian we are always looking to improve our technology and processes to give you the b…
-
Creating new schedule with cron expression ?Hi, I try to make new schedule every month for the time intervals from 10th to 15th and 25th to 30t…
-
XML filesHI, I'm trying to read selected fields from an XML file pulling out, for example, text between the …
-
How to Execute Parallel Workflows (without Custom Steps or Powershell)Hi all, The Setup: Aperture V2.2.8 on Windows Server 2012 R2 Current Situation: I have to run 8 di…
-
Convert Pass and Fail to 0 and 1Hi, Is the a quick way to transform Pass and Fail validations to numbers 1 and 0 respectively Regar…
-
Data Studio V2.0 Find DuplicatesHi Thank you for the answers around using Find Duplicates Workbench. I will investigate this long t…
-
Many to many lookup of matching wordsI have a table which I'm treating as a lookup table. It's format is something like. Key Value …
-
How to convert unix timestamps to human-readable date?Hi, Does any one know how to convert Unix timestamps to human-readable date? Example Unix timestamp…
-
4009: Exception occurredWhen filtering on a field I get an error 4009: Exception occurred
-
Using token authentication in SOAPHi, Up until now we have been using the username/password authentication in our SOAP calls, but we …
-
XML driver for ApertureHi, Does anybody on the forum know if it is possible to read semi-structured XML data into Aperture…
-
-
Data Studio V2.0 - Trend Analyse & Data Consumer DashboardsHi On the help documentation, there is no update on Trend Analyse and Data Consumer Dashboards If t…
-
ℹ️ Scoreboard Charts for DashboardsCharts can be created as bar charts, line charts, pie charts etc. These charts can be collated toge…
-
Notifications in Aperture - email contentHi everyone! I have a question related to the email content on the notifications section. We are tr…
-
Calling subroutinesHi, When there are more that 1 outputs from a subroutine is it possible to distinguish them in the …
-
Aurora database connection?Hi, Our client MDM has been built on an aurora database platform. Is there a connector for Aperture…
-
ℹ️ Importing your Datasets into Excel or Tableau using ODataYou can easily get your data from Data Studio into Excel or Tableau using OData. OData (odata.org) …
-
Changing Data Studio's default Language and Region settingI recently needed to change the default Language and Region setting used by Data Studio when adding…
-
RestApi AuthorizationHello Where can i find the <Environment external label> in order to build an RestApi Author…
-
Which search type I should be using if i want to retrieve State and City from the zip code?Hi Team, I am using Address SOAP v3 validation API and I intend to use it to retrieve City and Sta…
-
Salesforce - User connection propertiesHi all, If we add a new column to a Salesforce table and refresh the data, it doesn't bring the on…
-
Find Duplicates Language for Notepad++If you're using Notepad++ as your text editor, it can be helpful to have an interpreter to highligh…
-
Data source and "Filter regular expression" - How it works?Hi, does anyone know how System -> External systems -> "Filter regular expression"…