Swap Primary and Secondary Data Sources

tableaucommunity@tableau.com — Thu, 30 Nov 2017 18:14:48 GMT

I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. Currently, I have to rebuild the worksheet and bring in the secondary source first. This would be a great time saver, with all of the calculations and linking changing as well.

Add 'IN' operator to Table Calculation

tableaucommunity@tableau.com — Wed, 13 Feb 2013 16:24:43 GMT

Often times we have to insert a list of codes into a table calculation: example:

IF([ICD9_PX (Primary) - Code] = '36.11'

or [ICD9_PX (Primary) - Code] = '36.12'

or [ICD9_PX (Primary) - Code] = '36.13'

or [ICD9_PX (Primary) - Code] = '36.14'

or [ICD9_PX (Primary) - Code] = '36.15'

or [ICD9_PX (Primary) - Code] = '36.19')

THEN

1 END

Why not create an 'IN' operator similar to SQL which would be much more efficient?

CASE WHEN ([ICD9_PX (Primary) - Code] IN ('36.11'

,'36.12'

,'36.13'

,'36.14'

,'36.15'

,'36.19')

THEN 1 END

IF [ICD9_PX (Primary) - Code] IN (''36.11' ,'36.12' ,'36.13' ,'36.14' ,'36.15' ,'36.19')

THEN 1 END

We would also want a calculation for the 'NOT IN' as well.

Content in Tableau Community Forums

Swap Primary and Secondary Data Sources

Add 'IN' operator to Table Calculation