KNOWLEDGE BASE

Japanese Big Characters And Small Characters Are Joined When Connecting To Excel Data Source


Published: 24 Apr 2018
Last Modified Date: 21 Jun 2018

Issue

Japanese has bigger characters (upper case) like シヨウ and smaller characters (lower case) like ショウ, which have different meanings and pronunciations. In Tableau Desktop 10.5 or Tableau Desktop 2018.1, these characters are case insensitive and ショウ (lower case) is joined to シヨウ (upper case) when connecting to Excel file data sources.

This issue does not occur in Tableau Desktop 10.4 and earlier versions of Tableau on Japanese OS, but occurs on any version of Tableau Desktop on English OS. Also, the issue does not exist, if data sources are CSV files.

Environment

  • Tableau Desktop 10.5.0 - 10.5.4
  • Tableau Desktop 2018.1.0 - 2018.1.1

Resolution

Option 1

Upgrade to Tableau Desktop 2018.1.2, 10.5.5. For more information, see Upgrading Tableau Desktop in Tableau Help.

Option 2

Convert the Excel sheets to CSV files and join the CSV files. 

Cause

This behavior is related to a known issue (ID: 767724) which has been fixed in recent releases of Tableau Desktop. 

Additional Information

Note:
 "ショウ" has totally different meaning and pronunciations from "シヨウ". See below example
  • "ショウ" means "show", which is pronounced as "show".
  • "シヨウ" means "expected behavior", which is pronounced as "shi-yo-u".
Did this article resolve the issue?