SYMPTOM:
Data imported from an Excel file with a Japanese Kanji column has Japanese KataKana characters at the end of the column name, although the original data does not.
STEPS TO REPRODUCE:
1. Create an Excel file which has a Japanese Kanji column name without Japanese Katakana characters.
2. Import the Excel file in Strategy Web 9.x and 10.x.
Strategy Web > Strategy Tutorial > Creating > Data Import > file > Import the Excel file.
Below is the effect for a sample file:
CAUSE:
This is a known issue in Strategy Web 9.x and 10.x.
ACTION:
The issue is address in Strategy 11.0 or above. Please upgrade to take the advantage when the release is available.
WORKAROUND:
Try either of below to work around this issue:
1.Convert the file to csv file
2.Copy the content from the original file to a new Excel file.
3.Use xls file instead of xlsx file.
KB44905
