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
-
Sample DataWe're looking to not deliver sample data with the installer for v2.0. Instead we are looking at usi…
-
Inferring Gender from Title or Honorific and Gender ReversalSometimes it might be useful to determine the gender of a person from their honorific, so for examp…
-
Impact of snapshots on memoryHi, I am using a job that has several input snapshots defined in it, though I only connect 2 of the…
-
Data Studio v1.6.2 is now available!This maintenance release resolves several issues caused when executing workflows using the REST API…
-
Creating a Blocking Key from more than one Generic StringI want to write my own blocking key, but the data I am working from has several field which are all…
-
Is it possible to 'pull' data from Aperture Data Studio into Excel?Hi, Whilst there is the option to export data from Data Studio into Excel, is it possible to pull d…
-
Is it possible to reuse the result dataset extracted from Datawarehouse?Scenario 1: Once the required dataset is taken from any Datwarehouse, how can we reuse it for analy…
-
Approach for Matching Product data (product description)Yesterday @MiteshKhatri @Akshay Davis @Katya Jermolina and I were having a discussion about approac…
-
Slow data loadMorning, Last night I created a sample data set that I am going to use to test our de-duplication m…
-
Custom date of birth - MatchingHi, As part of our matching process we break date of birth into day / month and year and then have …
-
How can we connect to a view in SQL Schema using JDBC connectionI am able to connect to table and see the columns using JDBC connection. How can I check the views …
-
Extracting the country from an unstructured address using a lookup list of countriesThe problem that you may need to solve is that you have data that is effectively a contiguous strin…
-
Accesing data from quick sense filesHi everyone, I'm new in data aperture and I have a client who calculates KPIs in a quick sense repo…
-
Cross-system and cross-table relationship discovery automationIn our customer cases data quality issues are often cross-system inconsistencies. Technically, cust…
-
Sequence countHi, I can't find a sequence count in Aperture - is there one planned in Version 2.x? Nige
-
Data Studio and MDMIt sometimes gets asked how we co-exist with an MDM system. We have many customers using Data Studi…
-
Use of SQL to refine source data prior to loading into ApertureHi, I was just wondering whether other users would find a Pandora-like feature to pre-filter prior …
-
Column Exceeds maximum allowed ?Anyone any ideas ? I was getting the problem on the postcode column so ran a length check and restr…
-
Availability of source file/table metadataHi, We are using Aperture to compare profile statistics from 2 tables from different SQL databases…
-
Purging LogsDoes anyone else see this in their logs ? Seems strange that the application is constantly purging.
-
Post Code improvementIf a UK postcode is listed in format AB123CD AB12CD A12CD How can I strip this out to a normalised …
-
Is UniqueI've had a few questions around checking if a value is unique in a column. Voila: (Thanks @Ian Thor…
-
Extracting a specific piece of information from an address using regular expressions and lookupsData Studio has several built-in functions to allow you parse strings of text and extract a particu…
-
Workflow comments and notesIs there any way to create and display comments or notes within a workflow? An example might be som…
-
How to trigger an e-mail notification if a job failsData Studio has a range of default notification options which allow you to send a custom email to d…
-
Checking data like social security numbers (SSN) for correctnessSocial Security Numbers, National Identity numbers and the like, on face value are simply strings o…
-
Removing value (NULL) from Excel spreadsheetsHi, Quick question, can Aperture handle while loading a replace task for a specific set of values ?…
-
Checking data like social security numbers (SSN) for correctnessSocial Security Numbers, National Identity numbers and the like, on face value are simply strings o…
-
Sharing database connections across teamsWhat's the recommended approach to sharing tables/views and connections to databases across a wider…
-
Getting started with Regular Expressions in Data StudioA regular expression (from here on we’ll call them “regex” for short) is a well-known and powerful …
-
Tips to improve workflow performanceIf you ever find that a workflow is taking a long time to execute, you might want to think of ways …
-
Using a discriminant for Find Duplicates clusteringFind Duplicates will use fuzzy matching to link records, however, in some cases you may have a disc…
-
Data Studio v1.6.0 is now available!The latest version of Data Studio introduces new features, existing functionality enhancements, per…
-
Creating a new data connection to Salesforce from Data Studio via JDBCIt is likely that quite soon after you start to use Data Studio you will want to connect Data Studi…
-
Changing source file schemae and data definitionsLegacy system files often come without a schema or data definition embedded in the file, and if the…
-
JDBC Performance issues can simply be about securityIn Data Studio you have a number of different ways of accessing data. File Based methods Data conne…
-
Refresh your sourcesOccasionally you may find that the staged sources fall out of synch in how Data Studio renders them…
-
How to resolve a unmapped source on a workflowIn a previous tip I suggested you might want to export and import your workflow between systems. …
-
Data Wrangling - is it so bad?An interesting perspective from Pete Aven of Marklogic, popped up in my feed this week, written on …
-
Why might my Find Duplicates results look different?If I use the Find Duplicates step on its own, in some instances I get more clusters of records (clu…
-
Do businesses run on premium data? New study assesses variables in data quality toolsLisa Ehrlinger from Johannes Kepler Universität Linz Linz, Austria, and her team have identified 66…
-
Jobs with large lookup filesAt St. James's Place, prior to highlighting whether client details need to be quality checked, we n…
-
Data Studio v1.6.0 is coming soon!Coming up in the next version of Data Studio: ability to select a predefined custom layout for the…
-
Finding your User Id in Aperture Data StudioHow do I find the import directory for my user (amongst others)? On the server, if you head to your…
-
Dealing with PIITalking to a prospect today about PII - identifying it on data loaded into the system and then proc…
-
Using 'Matches' functions to identify personal information (and automate the detection of this)Following on from @Steve's discussion (here), I wanted to share some further thoughts on this subje…
-
When should I use a Match Lookup rather than a joinI have a large amount of data (hundreds of millions of transactional records) that I need to match …
-
What's better invalid data or missing data?A discussion that seems to come up from time-to-time is, whether it is better to have gaps in your …
-
Extract a number (6-char SIC code) from a string and perform a lookup (2-char SIC to get category)Using some of the Company's House open data, I recently built a simple workflow that extracts the S…
-
Floating Point numbers with Microsoft Excel Open XML Spreadsheet (.XLSX) filesWhen using .XLSX files in Aperture, be aware that floating point numbers will be treated differentl…