tips and tricks
Discussion List
-
Use of If-Then-Else logic in Aperture Data StudioImagine you are asked to use Aperture Data Studio to generate a new field for your sales data. You…
-
Importing and Exporting WorkflowsOne of the very first things that you will probably wonder, is just how portable are my workflows t…
-
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…
-
Extract Title from NamesDuring the course of the data preparation that you might be doing on names, you might have occasion…
-
Grouping in V2 and differences with V1if you're working with financial data with Aperture Data Studio, one of the things that you might w…
-
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…
-
Checking data like social security numbers (SSN) for correctnessSocial Security Numbers, National Identity numbers and the like, on face value are simply strings o…
-
Checking data like social security numbers (SSN) for correctnessSocial Security Numbers, National Identity numbers and the like, on face value are simply strings o…
-
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…
-
Validate Customer data example WorkflowThis simple validation workflow leverages the Sample Data of Customer V1, The FILTER step filters t…
-
Joining Data example for Purchase Order Headers and LinesThis workflow uses PO sample data The PO header and rows, is joined using the order number This wo…
-
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. …
-
-
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…
-
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…