KNOWLEDGE BASE

Error "ColumnTable: Schema/DataTable mismatch" when subtracting dates


Published: 18 Aug 2017
Last Modified Date: 17 Nov 2017

Issue

After converting a Date & Time field to Date, and creating a calculation with the formula MIN(Converted Date) - MIN(Converted Date), the following error occurs:

ColumnTable: Schema/DataTable mismatch

Environment

Tableau Desktop 10.3.0-10.3.3

Resolution

Option 1

Upgrade to Tableau Desktop 10.3.4, 10.2.6 or 10.4.1. For more information, see Upgrading Tableau Desktop in Tableau Help.

Option 2

If you are unable to upgrade, please use DATEDIFF(). For example,

MIN( [Date] ) - { FIXED [ID] : MIN( [Date] ) }

could become

DATEDIFF('day', MIN( [Date]), { FIXED [ID] : MIN( [Date] ) } )

Cause

This behavior is related to a known issue (ID: 664788) which has been fixed in a recent release of Tableau Desktop. 
Did this article resolve the issue?