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

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

Issue

Japanese has bigger characters (upper case) like シヨウ and smaller characters (lower case) like ショウ, which have totally different meanings and pronunciations. In Tableau Desktop 10.5, 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 and later

Resolution

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

Cause

This issue is under investigation as ISSUE ID 767724.

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?

Thank you for providing your feedback on the effectiveness of the article.