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
-
Renaming the Datasets and share to other Spaces togetherIs there a quick way to rename all the datasets together. Example wants to add some prefix to all d…
-
Experian Data Studio Job Stuck.Hi, One of the experian data studio job is stuck for 23h on our dev server, we have tried to cance…
-
FunctionsHi, I'm working with Functions. Re:product development, it would be a really useful to be able to m…
-
Aperture data studio log file locationHi, I have noticed something now in our prod servers. The log file generated for aperture data s…
-
Importing data form a cloud-based MDM solutionHi, We need to import data into Aperture Data Studio from Boomi’s Master Data Hub module. As a clou…
-
Word FrequencyEvery now and then a scenario crops up where it'd handy to know how often a given word occurs withi…
-
Is there an function to identify extra spaces between words?Hi, I would like to check if is there any out of box solution for identification of extra spaces be…
-
-
How to convert a value using if-then-else?Hi, I've created the following function to convert an input to zero if the input equals to null an…
-
SAP Views as DatasetsHas anyone used SAP views as a datasets? I have a strange situation where SAP View can be defined t…
-
How to export line breaks?Dear All! In the workflow I'm running I have loaded a dataset (from excel) containing line breaks. …
-
Huge HPROF file in installation folder.java_pid2376.hprof What is an HPROF file and what is it doing in my ADS installation folder. C:\Pro…
-
2 questions on TRANSFORMLooking for ideas from community. 1) Transform – ‘Equals’ Command I am in a workflow to check if …
-
Filtering within a validation ruleHi, I have the following scenario for a validation rule and I'm struggling with the logic. Column…
-
Workflow not completed - notificationHi All! Is there a way to set an (e-mail) notification in case a workflow has been stuck? Meaning …
-
Schedule for every 2nd weekHi All! I've set a schedule for a workflow with the following criteria: Recurrence pattern: weekly …
-
Notifications based on emails in the dataWe have 50 service desks placing orders for customers around the country. We want to monitor those …
-
Equals (Strict) functionIs there any documentation on the functions? I am looking for explanation for Equals (Strict) Funct…
-
How to determine Nth occurence in a column?Hello. Do you know of any function or combination of functions that can achieve a new column in the…
-
How to setup Google Big Query as an external system for pushing data into BigQuery tableHi, Did anybody try using the Google Big Query 6.0 JDBC and know how to configure the credential de…
-
Anyone using SAP Tables with LRAW type columns (Example: STXL)We need to bring in SAP STXL table to Aperture. This has an LRAW type column named 'Data'. This is …
-
What are the limits of data loading in Data Studio?Back in June, I read an internal post by @Henry Simms that suggested that in test we had loaded 16…
-
NI No ValidationHi, Can somebody please advise on the algorithm used in the NI No (UK) validation step. I am findin…
-
What "4016: Functions exception occurred" means?Hi, I'm creating a workflow with a large set of validation rules (110 rules and 74 groups) and whe…
-
Documenting Aperture Data Products with MetadataIn complex Aperture environments, like in any data environment, you need to understand what data yo…
-
Creating charts from workflowI've added a chart step to one workflow but when running it I cannot see the chart under the chart …
-
Oracle Java SEHi, Does Aperture data studio and Find Duplicates installers has embedded java installer that upda…
-
How to do pivot Column to rowsI have rule1, rule2, rule3 in the column names and corresponding count in the rows, now I want to g…
-
Harmonize Duplicates - Select best record based on score with multiple criteriaA customer posted this question to me: "I want to pick a survivor using multiple score based c…
-
Format number to 2 DPsI have some data that I'm importing and I want to convert to currency format nnn.nn - there doesn't…
-
Spelling CheckI've quite a few datasets that have spelling problems or words with number instead of a letter and …
-
Remove rows that have null value?I'm creating a dataset from a snapshot and I would like to remove rows that have null value on a sp…
-
Not been able to drill down from a view created from profile data stepI've created an interactive view from the profile data step however, after publishing the view I'm …
-
Group step in Workflow throws java.lang.IllegalArgumentException: Invalid handleHello there, I have a workflow in Experian's Aperture Data Studio (version 2.5.11.115) which unions…
-
Low Disk Space Notifications and others.Hi team, this is to ask you if I create a low disk space notification on aperture data studio syst…
-
Find Duplicates Blocking Keys and Rules in v2If you have the license for Find Duplicates Fuzzy matching then you could use this functionality to…
-
Setup Secure SSL using self-signed certificatesIs anyone able to provide some clear instructions on how to generate and install a self signed cert…
-
APIs to get the details regarding Data set and wf schedulesHow do I get Information about all the datasets refresh which have been scheduled and timing of tho…
-
I want a column to only accept 'A, 'B', 'C' or 'D' as the correct values.I want to restrict the values for a certain column. It should only accept either 'A, 'B', 'C' or '…
-
How to check if an input value contains numbersIn Aperture Data Studio, in order to check if an input value contains numbers, you can use the Matc…
-
How to validate US dates stored as YYYY-MM-DDI have several fields that have dates stored in the format above. If I run the built in function &q…
-
Find Duplicate - Based on different criteriaHello, Requirement is find the duplicates based on 3 different criteria - Name and Phone Match Na…
-
Aperture API to get the health of the system CPU UsageCan we get the health of the environment through API? What is TenancyID? how can we get the CPU us…
-
Find Duplicates - Address Element MappingHi I am trying to find duplicates in data from multiple countries. I'm mapping company name to &qu…
-
Setting up a parameter to work across multiple workflowsHi, I have a workflow parameter that feeds into both a column and and export. The problem I have is…
-
Issue with Views when upgrading to v2.6.3, v2.6.4 and v2.6.5We are aware of an issue that affects some installations of Aperture Data Studio versions 2.6.3, 2.…
-
Do you have a need for Pivot/Unpivot steps?As part of our product discovery activities, we would like to find out if any of our clients have a…
-
Force workflow failure due to failing rowsIs there a way I can force a whole workflow to fail as a result of failing rows in a validation ste…
-
Performance decrease since upgrade to version 2.6I have experienced significant performance decrease since I upgraded Aperture from 2.4.9 to 2.6.0. …
-
Enabling LDAPIn case you haven't noticed, LDAP has been introduced since Aperture Data Studio v2.0.11. Go to Set…