Alteryx Designer

Definitive answers from Designer experts.

There were errors with LOADING please check your ERROR TABLES, using Output Data tool to Teradata with French characters

Alteryx
Alteryx
Created

Environment Details


The following error occurs in the Output Data tool of the workflow related to French characters (such as "TÉLÉBEC") when saved to a Teradata table:

There were errors with LOADING please check your ERROR TABLES

idea Skyscrapers


Alteryx Designer ≤ 2020.1.2

  • Teradata ODBC 64-bit/32-bit Drivers
  • French Character set data


Cause


Data type related issue within the Alteryx tools.



Resolution


Before the Output Data tool, use the Select tool to change the datatypes of all the columns that contain French character data to V_WString. Click here for more details on the Select tool.