String being truncated when loading data

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

Input

Accepted answers

Joe_Mako

Can you post a screen shot of your Input Data tool Options?

Here is an example of what I set mine to when I have records with long values:

All comments

Joe_Mako

Can you post a screen shot of your Input Data tool Options?

Here is an example of what I set mine to when I have records with long values:

razzy

So what if your input is from a database directly using an sql query in oracle database and i am having the truncation problem too, whats your tick on it and how may i work around it. The above solution you provided is correct provided if your are inputting a saved file.

Thanks.

BlakeFox

@Joe_Mako Hi, if you get the chance please take a look at my tool configuration below. The input file is a .csv file with a single field and url record. What am I doing wrong and why do I still have truncated data in the cell?

csv input config2018-11-14_13-40-34.jpg result csv tool2018-11-14_13-40-58.jpg

davidhenington

how is this solved?

This is an issue in many of these threads. They are marked as solved and simply are not.

@LeahK @NeilR Thoughts?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703