Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Character limit in a certain column

Sjkitts
7 - Meteor

I'm currently having trouble with my character size in a column . I need this column to be exactly under 260 character limit but not to cut off in the middle of a word. Is there a tool I can use to complete this? In the screenshot the red marker in the upper right corner says "This Cell has Truncated Characters". Even when I go back to an even further select tool it shows the size to be 2147483647 which doesn't really make sense.  See below for screenshots. 

2 REPLIES 2
IraWatt
17 - Castor
17 - Castor

Hi @Sjkitts,

Your cell there is not being truncated double click on the cell and view it like this to see more:

IraWatt_0-1655911709418.png

to get the full view use a browse tool and double click on the cell again, like this:

IraWatt_1-1655911766515.png

 

 

ddiesel
13 - Pulsar
13 - Pulsar

Hi @Sjkitts!

 

I second the information @IraWatt provided about the data not being truncated.

 

To address your question about getting the text in a field under a specific length without cutting off in the middle of the word, here's one way to do it:

 

Capture1.JPG

 

Hope this helps! Let us know if this will work for you.


Thanks,

Deb

Labels
Top Solution Authors