Skip to content

Instantly share code, notes, and snippets.

@cmtoomey
Last active August 29, 2015 14:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cmtoomey/dcfdebf5011655d6f991 to your computer and use it in GitHub Desktop.
Save cmtoomey/dcfdebf5011655d6f991 to your computer and use it in GitHub Desktop.
How to map new and old Tableau Datasources
<?xml version='1.0' encoding='utf-8' ?>
<datasource formatted-name='XXXX' inline='true' version='9.0' xmlns:user='http://www.tableausoftware.com/xml/user'>
<!-- build 8100.14.0717.0952 -->
<connection class='New Skool DB' dbname='DB' odbc-connect-string-extras='' port='####' server='some_connection_string' single-node='no' sslmode='require' username='username'>
<relation name='database' table='[Tables/Views].[Contacts]' type='table' />
<cols>
<!-- Paste all the new XML in here -->
<map key='[MyPeople]' value='[Contacts].[mypeople]' />
<map key='[YourPeople]' value='[Contacts].[yourpeople]' />
<map key='[OurPeople]' value='[Contacts].[ourpeople]' />
</cols>
</connection>
<column datatype='integer' name='[Number of Records]' role='measure' type='quantitative' user:auto-column='numrec'>
<calculation class='tableau' formula='1' />
</column>
<layout dim-ordering='alphabetic' dim-percentage='0.5' measure-ordering='alphabetic' measure-percentage='0.4' show-structure='true' />
<semantic-values>
<semantic-value key='[Country].[Name]' value='&quot;United States&quot;' />
</semantic-values>
</datasource>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment