Input data tool - SQL select converting nvarchar column to binary

Question

I am getting data from DB using a SQL query. My table has some column which is defined as NVARCHAR. Input data output of that SELECT query is converting those NVARCHAR columns to binary. I am not able to prevent that conversion. Need help in avoiding that conversion.

SandhiyaGandhi · Answer

Thanks for your reply.

grazitti_sapna · Answer

@SandhiyaGandhi, you can try to cast that particular column into the string and bring in the Alteryx in case the values are being changed. Also, Alteryx does not have nvarchar as datatype instead it has string data types.

Please refer to the link with the supported data types- https://help.alteryx.com/20221/designer/data-types

I hope this helps!

Thanks!