KNOWLEDGE BASE

Data Is Duplicated After Incremental Refresh


Published: 26 Feb 2015
Last Modified Date: 10 Sep 2015

Issue

When using incremental extract refreshes, data duplication might occur.

Environment

  • Tableau Desktop
  • Extract configured with a DATETIME increment key

Resolution

Wrap the DATETIME field in a truncate function. For example: 
TRUNC_TIMESTAMP([DATETIME])

Cause

The date time field in the database is more precise than the date time that is recognized by Tableau Desktop.
Did this article resolve the issue?