Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

Question about getting final word of each row.

dhxodud96
7 - Meteor

I'm having trouble with getting final word of each song title.

 

final word of each song title.png

 

In order to use the left, right, etc. of the Formula tool, i need to set the length of the words.

Currently the last word in data are of different lengths.
Which tool can I use to get the value?

 

Always thanks for helping me.

2 REPLIES 2
aatalai
14 - Magnetar

@dhxodud96 put this in the formula tool

 

ReverseString(
GetWord(ReverseString([Top 100]), 0))

 

also attached a workflow for reference

dhxodud96
7 - Meteor

thank you so much! have a nice day :)

Labels