Calculate string length and store it into new column

Hey, I'm pretty new to Alteryx and I'd like to calculate the length of each row in a string column and save it to a new column. I don't know if that's even possible using Alteryx, but the file is so large it renders Excel out as possibility.

Every tip is highly appreciated!

Transformation

Accepted answers

Kenda

Hey @fogellnagel!

This is definitely possible with Alteryx! Simply add a Formula tool, create a new output column and name it whatever you'd like then use the following expression:

Length([Field1])

where Field1 is the name of the field you want the length of.

length formula.PNG

All comments

Kenda

Hey @fogellnagel!

This is definitely possible with Alteryx! Simply add a Formula tool, create a new output column and name it whatever you'd like then use the following expression:

Length([Field1])

where Field1 is the name of the field you want the length of.

length formula.PNG

fogellnagel

Aah that's easy, thank you very much!

RNG

Hi,

I am new to Alteryx and I would like to get the string length (Field2) which is grouped by year (Field1) and store it in a new column (Field 3). Post which I would like to get an average of Field 3 and store in a new column. The output should be year wise average string length

Field 1: 2013, 2014, 2015....... (upto 7years)

Field 2: strings of varying length (700 line items)

Please help me accomplish this.

Thanks for your support in advance.

avisingh96

Hi Community,

Is there any possible way to count the number of characters in a word.

Thanks in advance.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703