Importing text heavy fields

jonathanogrady

Hello fellow Alteryx fans!

I had a quick question which I was hoping some genius out there might be able to help me with please?

I would like to import a CSV file. Two of the fields are text heavy and have circa 5000 characters in length.

I went to the configuration for the input Data tool, and set the field length to 8000… Should be enough, right?

However, when I import my CSV file I'm finding that it is still truncating each field after 255 characters.

The balance of the data appears to be missing? I would like to have a complete dataset…

What stupid mistake am I making?

All dummy data, so happy to attach below.

All help much appreciated!

Jonathan

Geo-Data.yxmd

Error Message

Accepted answers

Philip

I'm not sure what you mean by the data cleansing tool truncating. I did a comparison of pre- and post- data cleanse and the data looks fine to me.

Intermediate_Step2_RegExAnalytics solution compare lengths.yxzp

All comments

jonathanogrady

CSV file attached…

UNESCO World Heritage Sites Dataset.csv

Philip

When I run it, it's not the Input tool that's truncating, but the Select tool (3). Specifically the short_description_en and short_description_fr.

It appeared that the text encoding was messing things up, so I changed the Input tool text encoding to ANSI - Central European and it no longer truncated.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703