Error "Unable to materialize temporary table" Using Microsoft SQL Server Data Source With Multiple Joins
Published: 06 Oct 2016
Last Modified Date: 04 Oct 2017
IssueWhen creating an Extract from a multiple join MS SQL data-source connection the following errors are returned:
Unable to materialize temporary table
Error materializing temporary table: EncodeString: bad argument
- Tableau Desktop 10
- MS SQL Server
ResolutionMake sure that there is a match between data type and content for each field used in the join.
CauseTableau creates a temporary table to materialize the join but finds a mismatch between data type and content for one or more fields, for example finding a 'Date' when a 'String' is expected.