KNOWLEDGE BASE

Importing RData File With NaN Value Shows All Rows With NaN


Published: 12 Jul 2018
Last Modified Date: 13 Jul 2018

Issue

When using Tableau Desktop to import an RData file as a text file data source that contains a column with a 'NaN' value, then all rows in that column will become 'NaN'.

Environment

  • Tableau Desktop 10.3,10.4,10.5
  • Windows 7
  • R File

Resolution

Option 1

Upgrade Tableau Desktop to 10.3.13, 10.4.9, 10.5.6, 2018.1.3 or a later version. For more information, see Upgrading Tableau Desktop in Tableau Help.

Option 2

As an alternative workaround, try the following steps below: 
  1. In the data preview pane, change the data type of the affected field to 'String'. 
  2. Go to 'Sheet 1' 
  3. Create a new calculated field and enter a formula similar to:  
FLOAT([affected field]) 

Cause

This behavior is related to a known issue (ID: 736997) which has been fixed in a recent release of Tableau Desktop. 
Did this article resolve the issue?