KNOWLEDGE BASE

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


Published: 18 Aug 2017
Last Modified Date: 21 Aug 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

As a possible workaround, 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 with ID 664788 which is currently under investigation.
Did this article resolve the issue?