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