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
-
Tell us your experience in setting up and using external systems (databases/cloud storage services)To our valued customers, Being able to load data from external databases and cloud storage service …
-
Extracting titles and honorifics from names (advanced)In this earlier post I described how you might want to extract titles or honorifics from a name str…
-
Where could I find more information on how to use "Query duplicates store"?Hi, I am new to Aperture Data studio and one of my recent requirement is to use a supplied contact …
-
Quick Poll: Do you have a paid certification for a software product?Certifications seem like are a great way to demonstrate that you have the experience and technical …
-
Sign up to the latest data quality webinar "How to eliminate poor CRM customer contact data"Hi all, Experian is holding a free webinar on “How to eliminate the impact of poor CRM customer co…
-
Automated Data Tagging in v2.1In v2.1 you now have the ability to automatically tag your data using the predelivered data tagging…
-
Address ValidationMorning My Address Validation in V2 is no longer working, wont allow me to select "country&qu…
-
Data Stewardship PrioritiesWhen you think about Data Stewardship, what does that really mean to you and what do you think matt…
-
Extract Title from NamesDuring the course of the data preparation that you might be doing on names, you might have occasion…
-
Finding earliest date in a clusterHi I have multiple rows for a customer and each row has a modified on date. I want to find the earl…
-
Trim a leading wordIn this brief clip i will show you how to trim a leading word from a field. In this case i am trimm…
-
Datasetdropzone directory changes in v2.1.2Hi all, I’m writing this post to inform you all on the upcoming change to the datasetdropzone direc…
-
Export directory changes in v2.1.2Hi all, I’m writing this post to inform you all on the upcoming change to the Export directory in v…
-
Harmonisation in V2.0 Data StudioHi Trying to understand the best way to get a better harmonised record, when you have multiple line…
-
Export - JDBC error - formula to ensure a column has a right lengthHi I am loading 1.9 million records back to database and l will often receive this message (part of…
-
Salesforce tables have different columns after upgrading from Data Studio v1 to v2If you've previously used Data Studio v1 to load data from your Salesforce instance, and have upgra…
-
Notification setup to trigger ScheduleHi I have set up a notification, so when a few datasets are loaded, it kicks of the schedule im str…
-
Upgrading to a new release for Aperture Data Studio v1 versus v2Up until now, we have had 23 releases for Aperture Data Studio v1. In order to upgrade from one re…
-
Tell us what we can do to improve your Aperture Data Studio administration experienceHi everyone, We have created a survey for you to share with us your opinion on your Aperture Data S…
-
Copy a space - workflows, datasets, exports, snapshots within the same serverHi At moment l have setup a space for single view of customer. Business would like to copy the full…
-
Export to JDBC - not loading but Job completingHi I have an export step that goes to JDBC database. We have another table in the database thats wo…
-
Subtotal of Dataset to Workflow - alertHi Is there away that when a dataset is loaded via datasource or dropzone into Aperture, that when …
-
Attention all V1 & V2 users...Today we have launched a new sub category, Migrating from V1 to V2, which contains posts to aid you…
-
Triggering workflow executions upon file arrival in Aperture Data Studio v1 versus v2Aperture Data Studio is commonly used for operational data quality management. This would mean that…
-
Address Validation v 2.1I am blown away by the speed of the Batch Address Validation processing on NA addresses in this rel…
-
Ensuring you always return the same duplicate ID with Find DuplicatesFind Duplicates returns consistent Cluster ID after each run. Consistency here applies to the seque…
-
Tagging - remove tagsHi I have workflows that have columns with tags. When l union because not all the columns tagged th…
-
Profiling Data for the first time and changing the underlying dataThis short video illustrates the ease with which you can define a dataset, profile the data to dyna…
-
Cleansing FieldsHi I have fields that are quite messy when l receive them. We will be going back to source and clea…
-
EdgeHi, Overnight Edge (the company default browser) has been upgraded - does this improve things for A…
-
Splitting full name - Last nameHi I have Full name fields, data is all represented in one field and l need to split this out to Fi…
-
Delta Data loads - Aperture v2.0Hi this is a follow on from the delta data loads for version 2.0. Not sure if a better way in v2.0.…
-
Address RationalisationHi all I am looking for an example of splitting an address into the different parts. I have an ad…
-
Split data from two columns - phoneshi I have a situation when l have a file that has two columns with phone data: Phone …
-
Phased deployment and secure collaboration in Aperture Data Studio v1 versus v2In Aperture Data Studio v1, there isn’t an effective way to compartmentalize objects such as datase…
-
Address validation - format the column firstHi I have a postal address column that has the data in one column and is in this format: 1 Smith St…
-
Phone Format - Australian LandlinesHi I have used the following to format australian formats Landlines can be in this format: 3999988…
-
Data ImprovementsHi I have a dataset that has the following fields (as a subset): First Name Middle Names Surna…
-
Fixed Width file parsing in Aperture Data Studio v1 versus v2Fixed width files may be one of the common file formats that you have come across and need to proce…
-
Phone numbers - consistent formattingHi I have phone numbers within applications that can be in many different formats for landlines and…
-
Automation of datsource as a datasetHi We have created a datasource that will update on periodic basis. To set this up to a workflow, l…
-
Formula - converting values into a field to another columnHi I would like to convert columns that we receive from an application and place into columns that …
-
Scheduling errorGood afternoon Relatively new to v2 so apologies if this is a user error problem ! I am trying to s…
-
JDBC connectionHi Can you please let me know if there is/planned to be a JDBC connection for Optymyze? Thanks Nige
-
Function to calculate the number of working days between two datesRecently I wanted to create a function in Data Studio to calculate the number of working days betwe…
-
Edit DistanceIn the Edit Distance function with Levenshtein or Jaro-Winkler we have a field "Length" …
-
Anyone got the Azure Blob Storage Datasource connection workingIf so, what URL did you use? Couldnt find documentation around this. Thanks for answering
-
Duplicate Match Status ConverterThis is not a difficult thing to do but is a bit time consuming. Find Duplicates Match status is nu…
-
Default Find Duplicates RulesetsAnother quick shortcut. This dmx file will import all the Find Duplicates default rulesets. These a…
-
How to systematically sample with a fixed sample size and varying population sizeI was recently asked how to build a Data Studio workflow that would output a systematically sampled…