Field size/Incorrect data instead of actual value coming thru Denodo ODBC data connection

Question

I'm using a Denodo ODBC data connection to pull data. A few, not all, of the text fields are showing field size instead of the actual text. The numeric and date fields are showing correctly.

Has anyone experienced this problem or has a possible solution?

danilang · Answer

Hi @ppetgra

Any field showing as xxx Bytes is normally interpreted as a blob in Alteryx.  You should see this if you click on the metadata button in the results pane.  If it is, you can try either

1. using a Blob Convert tool to convert the blob Field to a string

2. use an explicit Cast(If available) function in the SQL statement in your Input tool to do the conversion in the database.  You'll have to check the Denodo documentation for the exact syntax

Dan