Formula

[chiragpatel_1]

Hi,

In the below screenshots I have current file (first screenshot) and second (what I want it to look like). 

I want the group 1 column to follow the format in second file, how do I do this, it's a little bit confusing. Many thanks in advance

[IraWatt]

Hey @chiragpatel_1,

You can use the left function in a formula to get the first character and overwrite the column like this:

Left([Group1],1)

The community has some quick and easy videos on formulas and the Formula Tool here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20...

[chiragpatel_1]

thanks but i would end up with three T's and i want to rename the description column to TPA, how is that done. sorry should've mentioned that in my post.

so TP,, TR and TT would be called TPA