Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

untranslatable character error


Hi Team,


I am trying to insert into teradata table. I am receiving below message. Any idea how to resolve this issue?


Error: Output Data (287): DataWrap2ODBC::SendBatch: [Teradata][ODBC Teradata Driver][Teradata Database] The string contains an untranslatable character. Insert into "CA_Business_Info_Team"."NWACD_Attendee"("Concentration","Descipline","Course_Descriptor","Training_Type","Course_Title","Course_Date","Last_Name","First_Name","State","Producer_Type","Short_Name","DimProducer_Id","Region","RVP","AVP","Sales_Director","Sales_Manager","Agency_Name","Email","Dist","AID","Status","Count","Location","Delivery_Team","LMS_Source","Content_Owner","EMP_ID","Meeting_ID","Delivery_Hours","Agent_Producer_No_","Attestations","Consumption","Description","Full_Name","Job_Level","Job_Title","No_Direct_Reports","Service_Time","UACChannel_Cd","UACSource_Cd") Values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)






@Kavya432 There could be a special character in the dataset that the driver cannot read and insert into the table. What I would do is try to create a table with a sample tool, limiting the amount of rows going in. First try, try 1000 rows then 1500 rows and see where the issue is occurring. You can then find out that special character and get rid of it within the workflow. 

Alteryx Certified Partner



Sounds like a special, character is showing up in one of your fields. May be challenging in trying to find it, especially if there's a lot of records you're attempting to insert.


You could try putting a Select tool before the Output tool and see if any of the fields are showing up as V_WString or WString. If you do, try changing them to V_String and see if the insert completes.


Note that this may modify the value in the record so it will no longer match up with the source system which generated the data so you'll still want to try and identify what special characters are showing up in your data to make sure that it being altered does not have a negative outcome downstream.

Teknion Data Solutions


It helped. The data has been loaded. Thanks a lot Jimmy. Appreciate you help.