forums

Use these forums to ask questions and discuss Tableau.

MySQL Composite Keys - do they work?

Posted January 14th, 2008 by Ian Waring
in Data Sources and Performance

We have quite a long Excel database that contains a manufacturer code (3 letters) then a manufacturer part number; we know some suppliers use the same physical part numbers, but need to keep them separate from a data integrity point of view. We're exporting the data to MySQL for performance - but wonder if we define the manufacturer code and the part number as a composite key in the database, whether Tableau will handle them correctly.

We'll test these tomorrow, but if anyone has experience already, it would help our project timescales! Any ideas?

Ian W.

Add new comment

Comments

On January 14th, 2008 Erin Easter said:

Hi Ian, Tableau detects composite keys so that it can offer suggestions for creating join connections as well as for assigning the fields into dimension or measure roles. Otherwise the composite key should have no effect.

reply
On January 21st, 2008 Ian Waring said:

Magic Erin. Thank you.

reply
Syndicate content Subscribe to the comments on "MySQL Composite Keys - do they work?"