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. )

Additional Information


 
Did this article resolve the issue?