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
-
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…
-
Case sensitive menu and function searchWhen searching for functions in the left hand side of the workflow, I have noticed that the search …
-
The importance of profiling when using Find duplicatesWhen implementing Find duplicates in Aperture Data Studio we've seen many examples of the importanc…
-
Great article on building loyalty with a Single Customer View!Just sharing a great article written by @aysha_aktemur on how Aperture Data Studio empowers loyalty…
-
-
Removing an unwanted intermittent string from the start of an alphanumeric fieldAt St. James’s Place we needed to remove a string, that occurred intermittently, from the start of …
-
How can I drop and create a table when writing to a database ?I have a workflow which creates a table on an Oracle SQL Server. When the workflow is re-run, I wan…
-
Timeout during exportI have a workflow that is exporting to a new table in an external database, using the option to cre…
-
What happened to the Python step in Data Studio?In Data Studio v1.1 there was a Python Step - what has happened to that and what are the options fo…
-
Data Studio v1.5.1 is now available!This maintenance release resolves workflow and custom step backward compatibility issues as well as…
-
I cannot access any files I previously loaded through Data ExplorerSometimes you will find that the view of files in the data explorer is out of sync with what is sto…
-
Data Studio v1.5.0 is now available!The latest version of Data Studio introduces new features, existing functionality enhancements, per…
-
What is cross-field matching?What do i do if i have multiple addresses or multiple phone number fields in my web forms but my cu…
-
Data Studio v1.5.0 is coming soon!Coming up in the next version of Data Studio: Updated version of the address validation engine New…
-
Working with DatesI have a set of data that contains some dates What I would like to do, is split the day, month and …
-
How do you work out where the row comes from ?When you're combining data from multiple data sources that potentially have duplicated data, you ma…
-
Solving for literal null valuesDepending on the source that you are working with, you may find that you actually have literal null…
-
Dealing with character setsSometimes, the file that want to use with Data Studio will contain characters that would come into…
-
Fuzzy Matching logicHow does the fuzzy matching in the Find Duplicates step work?
-
Find Duplicates Step configurationWhat is the difference between the Name, Household and Address/Location choices in the default Fin…
-
Find duplicates step - why should I create custom rules?Find duplicates step - why should I create custom rules? The find duplicate step comes with three p…
-
What's your most used function?Which function in Data Studio do you use the most?
-
Work with all the dataOne of the key reasons to work with Data Studio is that you have the choice to work with all of the…
-
Data Studio v1.4.0 is now available!The latest version of Data Studio introduces several new features, performance improvements and a n…
-
What's the main reason you're using Data Studio?Feel free to leave a comment as well.