KNOWLEDGE BASE

Unable to Change Data Type in Input Step When Connecting to Box or Onedrive


Published: 14 Feb 2020
Last Modified Date: 14 Feb 2020

Issue

Unable to change data type in input step in Tableau Prep Builder when connecting to Box and OneDrive.
User-added image

and when changing the data type in cleaning steps, (e.g. changing data type from "number" to "string"),
unexpected "NULL"  may be returned.

 

Environment

  • Tableau Prep Builder 2020.1.1
  • Tableau Prep Builder 2019.4.1
  • Tableau Prep Builder 2019.4.2

Resolution

Workaround

When connecting to local Excel file from Tableau Prep Builder, the data type can be modified correctly in input step.
Download the data to local Excel file if possible.

Cause

This is a known issue that is under investigation by Tableau development team.
Did this article resolve the issue?