Data Is Duplicated After Incremental Refresh

Option 1

Wrap the DATETIME field in a truncate function at the datasource. For example: 

TRUNC_TIMESTAMP([DATETIME])

Option 2

Convert the relevant table joins to CustomSQL to CAST the DATETIME key as a truncated DATETIME field.
To view an example of the CAST function see Database SQL Reference: Cast* in the Oracle Knowledge Base. 

Option 3

Create a view at the data source. For more information, see Create a SQL View* (external site, w3schools.com).



*Although we make every effort to ensure links to external websites are accurate, up to date, and relevant, Tableau cannot take responsibility for the accuracy or freshness of pages maintained by external providers. Contact the external site for answers to questions regarding its content.