Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Embedded Newlines - Input Data from Redshift

Highlighted
5 - Atom

I've searched for the embedded newlines errors and all the solutions are for an error once data has been pulled into a workflow. My issue is that I'm trying to pull a field from a table in Redshift that has about 1800 characters.

 

When I use the input data tool the data is truncated when it's pulled in. I've gone into the ODBC admin configuration and in data type optios changed the max varchar from 255 to 2000 and the max bytea to 2000. The max LongVarChar default was already at 8190. 

 

When I run it, that field is being truncated to 237 characters still. 

 

I'm sure this is a simple fix, but I can't seem to find it. Any help would be appreciated.

Highlighted
14 - Magnetar

You also have to change the max field length in the Input Data tool

 

DavidP_0-1582272030580.png

 

5 - Atom

Thanks for the response, David. I'm trying to pull in a table from Redshift with ODBC format. 

 

I don't see an option to change the max field length here. See below:

 

input data.png

Highlighted
14 - Magnetar

Sorry, my mistake, with ODBC connections the field length is set in the ODBC settings.

Labels