Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

DE34435: R tool is not able to read in Chinese characters in the field names

clarab
Alteryx
Alteryx
Created

Environment Details

R tool is not able to read in Chinese characters in the field names. The field name after the R tool becomes "X.."
 

image.png
  • Alteryx Designer
    • Version(s): 2021


Cause

DE34435/TDALI-4173  has been logged to address this issue.

 



 

Resolution

As a workaround, import the first row of the data in Excel as data by doing the following:

image.png

Data with Chinese characters are read in correctly. The first row may be skipped for data manipulation in the R tool. When writing out from the R tool to an Excel, please select the "Skip Field Names" option in the Output Data tool:

image.png

In this way, the first row containing the column names will still be correct.