manually sort field

I have a field that has multiple rows, I need to sort them in a specific order (not alphabetically) how can I do that?

Parse

Accepted answers

All comments

@ysalgado
No "Thank you"? 😂

Can you provide the sample data in text format and elaborate what will be specific order?

@ysalgado please provide sample data and required output.

See attached I hope this explains what I am trying to do.

Alteryx community sort question.xlsx

Hi Raj, can you see the attached file that shows what it currently looks like and what order I need it? Any help you can give would be appreciated.

Alteryx community sort question.xlsx

Here's my approach:

Connect your accounts in desired order to the 'F' input of a Find Replace tool
Connect your data that contains the amounts to the 'R' input of the same Find Replace tool
Configure the Find Replace tool to find the entire matched case-insensitive whole word, and then;
Select fields from the data to append to your list of custom sorted accounts.

The Find Replace tool actually appends!

@ysalgado take a look at the select record tool, that might help if you want to manually select rows

Please review. If satisfied, kindly like, comment, share and/or accept as a solution.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15879

MarqueeCrew 13708

apathetichell 13703