KNOWLEDGE BASE

Tableau Prep Builder Does Not Preview Relevant Rows When Selecting A Value With Infinite Decimals


Published: 31 Jul 2020
Last Modified Date: 25 May 2021

Issue

When selecting a value of a measure containing many repeated decimals in Tableau Prep Builder step UI, the results preview does not render.

Environment

  • Tableau Prep Builder

Resolution

This behavior is by design. To work around this behavior, we can take a two-step approach:
  1. In a new Clean step, create one calculated field for each of the affected fields with the formula: ROUND([Affected Field Name], 14)
  2. In a subsequent second new Clean step, remove the original affected fields so only the rounded fields remain

Cause

Tableau Prep was designed to round infinite floating point number results to 14 places.
Did this article resolve the issue?