String being truncated when loading data

[azlevy]

Hi All,

I'm having a problem with a String field being truncated when loaded into Alteryx.

My input is a CSV file, and I have a field that goes up to ~1000 characters.

Despite changing the Field Lenght setting in the Input tool I'm still not getting the full field, but only the first 254 characters.

Can someone help me with that?

Thanks,

Andre

[BlakeFox]

@itahir04 With the file input tool, depending on the file type the configuration options will change. Try using a CSV file format to get the string length configuration.

[ntboen]

You may need to change the Default String column length in your ODBC settings.  It's in the Advanced Options.

[Parinita]

What if there are multiple input CSV files like 50 or 100 which we want to ingest in that case we cannot manually go and change the field length for each of the file. So any suggestion for this kind of scenario?

[AliOmran]

Hey mate, Please did you find a solution when reading from DB and have truncated for some filed! 

[Vivek4]

Hey, Did you find any solution for this issue? I am still having a issue after incensing values ODBC settings 

[Shan]

We can change the value of String Setting in ODBC Driver Default setting is at 255. Please see below Screenshot

Steps

Start -> ODBC -> Select Connection Name -> Configure -> Advanced Options... -> CHANGE (Default String column length)