Tableau 10.2 introduces join calculations, allowing string parsing and other operations to be applied to the native database fields to produce matching fields that can be joined. In the following example we want to join a table containing project and sample fields with a table containing those same fields embedded in a workflow name string.
We start by building calculated fields for the secondary data source to parse the project and name from the workflow Name string. Use nested SPLIT commands in this case.
...