Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Data and Metadata is in chinese.

rohit782192
11 - Bolide

How to convert Data and Metadata from Chinese to Alteryx in the Result window to English.

7 REPLIES 7
Deano478
12 - Quasar

@rohit782192 for this I think you'll wan't to look into the ConvertFromCodePage and ConvertToCodePage these functions are good for dealing with different code pages/Character Sets.

 

I have no real experience with these functions so that's all I can offer you

flying008
15 - Aurora

Hi,@rohit782192 

 

Could you please upload print-snap to show your want ? 

Hammad_Rashid
11 - Bolide

Converting data and metadata from Chinese to English in Alteryx involves a few steps, and it depends on where the Chinese text is located within the Alteryx workflow. Alteryx itself provides options for changing the language of the user interface, but if you specifically want to translate data or metadata within the workflow, you might need to use additional tools or methods.

Changing Alteryx User Interface Language:

  1. Open Alteryx Designer.
  2. Go to Options > User Settings.
  3. In the User Settings window, navigate to the General tab.
  4. Under the Interface Language dropdown, select English.
  5. Click OK to save the changes.

This will change the language of Alteryx's user interface, including menus and prompts, to English.

Translating Data within Alteryx Workflow:

If you have data in a Chinese language field within the workflow that you want to translate to English, you may use Alteryx's Text Translation tool or use an external translation service.

  1. Text Translation Tool:

    • Drag and drop the Text Translation tool onto the canvas.
    • Connect it to the input data.
    • Configure the tool to translate the Chinese text to English.
  2. External Translation Service:

    • Export the Chinese text to a file (e.g., CSV).
    • Use an external translation service or tool (e.g., Google Translate API, Microsoft Translator API) to translate the text in the file.
    • Bring the translated text back into Alteryx for further analysis.

Translating Metadata:

If you are dealing with metadata (e.g., field names, column headers) in Chinese and want to translate them to English, you may manually change the field names or use the Dynamic Rename tool.

  1. Manual Field Renaming:

    • Click on the field name in the Input Data tool.
    • Manually change the field name from Chinese to English.
  2. Dynamic Rename Tool:

    • Drag and drop the Dynamic Rename tool onto the canvas.
    • Connect it to the input data.
    • Configure the tool to rename fields from Chinese to English.

Remember that automatic translation tools may not always provide perfect translations, especially for domain-specific terms. It's a good practice to review and validate the translated data.

rohit782192
11 - Bolide

From where i can download Text Translation tool or set up the same.

rohit782192
11 - Bolide

any other than google translate.?

Labels
Top Solution Authors