In a Flow Directly Connected to Oracle, Data Is Not Output When String Type Date and TODAY() Converted by REPLACE() Function Are Compared and Filtered

Issue

In a flow directly connected to an Oracle table, when the TODAY() function is converted to the "yyyymmdd" format using the REPLACE() function and filtered, the data is displayed in the GUI but not output after executing the flow.
User-added image

The issue occurs when the calculations are created as follows:

Then filtering to TRUE only in Tableau Prep Builder, data is not output while the data is displayed in the GUI.

Environment

Tableau Prep Builder
Oracle

Resolution

Workaround 1

Do not use the REPLACE() function to convert TODAY() to "yyyymmdd" format but using the following calculation instead:

STR(YEAR(TODAY()))+RIGHT("00"+STR(MONTH(TODAY())),2)+STR(DAY(TODAY()))

Workaround 2

Convert the String type date field to Date type in Tableau Prep Builder, and compare it with TODAY().

Workaround 3

Publish the data source connected to Oracle as an extract, and then connect it from Tableau Prep Builder.

Cause

The Tableau Development team is currently investigating this issue under Known Issue ID W-13634413.

Click here to return to our Support page.

Open a new case

Click here to go to our Support page.

Get detailed answers and how-to step-by-step instructions for your issues and technical questions.

Find and share solutions with our active community through forums, user groups and ideas.

Browse a complete list of product manuals and guides. Available online, offline and PDF formats.

Learn how to master Tableau’s products with our on-demand, live or class room training.