KNOWLEDGE BASE

Leading Zeroes are Truncated When Loading GEO IDs


Published: 23 Feb 2017
Last Modified Date: 24 Feb 2017

Issue

When loading GEO IDs from Excel, leading zeros are truncated, so IDs beginning with 0 are not formed correctly, and maps might not display or display incorrectly.

Environment

  • Tableau Desktop 10.1.4
  • Windows 10
  • Excel

Cause

Data Interpreter is applying some INT or STR related cleaning and removing leading zeroes.
Did this article resolve the issue?