Data cleansing/sorting

[J_SS]

How do reorder the data set in Alteryx? I want FOUR from name column to be the start of every data set. I have attached a eg screenshot on how the input looks and what is the expected  output should look like. Can anyone guide me how to achieve this ? 

I was thinking about creating a input template and make alteryx use the template to sort the data set. But not sure how to achieve this.

Thank you.

[mceleavey · Accepted solution]

Hi @J_SS ,

You have not really included any information as to the logic you are applying, but given what you have provided you can achieve this by assigning a set number and then a number to each of the words, then using the Sort tool:

[J_SS]

Thank you very much. It worked.

[mceleavey]