The Differentiation of Japanese Characters:Half and Full-width Hiragana and Katakana

KNOWLEDGE BASE

The Differentiation of Japanese Characters:Half and Full-width Hiragana and Katakana

Published: 08 Nov 2016
Last Modified Date: 09 Feb 2021

Issue

When data is imported into Tableau from CSV/Txt/Excel, the Japanese characters Hiragana and Katakana are converted to be the same character.
eg;
Japanese characters: Hiragana(full-width) are converted to be the Japanese characters: Katakana(full-width/half-width)
Japanese characters: Katakana(full-width/half-width) are converted to be the Japanese characters: Hiragana(full-width)

Environment

Tableau Desktop 10.0.1
Text Files / Excel

Resolution

Upgrade to Tableau Desktop 2019.1 or later.
This feature is released since Tableau Desktop 2019.1

Hiragana and Katakana can be distinguished with the following setting:
Data > Maintain Character Case (Excel)
User-added image

Use a text file instead of Excel, and set the locale to English when importing the text file. ( select file Right Click > Text file properties, Select Locale: English. )