Start Free Trial

Alteryx Designer Desktop Discussions

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

Arrange result set manually

tanvir_khan
8 - Asteroid

Hi all:

 

I need to change the order manually from the result set. As given below, from some fixed inputs I need to change the order based on the name of the items for reporting. Can anyone guide me on this pls?

 

Input
Item|Count
Watch|500
Bottle|200
Unmatched|50
Laptop|100
Wallet|300

 

Output
Item|Count
Laptop|100
Bottle|200
Wallet|300
Watch|500
Unmatched|50

 

thanks!

1 REPLY 1
tanvir_khan
8 - Asteroid

FYI - Got an idea, indexing the rows manually using the formula tool and then sort the result set by index. 

 

thanks!

Labels
Top Solution Authors