Order of rows

[Danilo9017]

Hi All

I am really struggling again the order of some rows. I have this input 

But i want have this type order output: 

Is it possible to obtain this output above with Alteryx ? Thank you!! 

Danilo 

[Felipe_Ribeir0 · Accepted solution]

Hi @Danilo9017 

If you always have the same Type's, right before the table tool you could join your dataset with a text input that contain the expected order of types, and after the join, order by the RecordID

Type	RecordID
network_cost	1
fee	2
dispute	3
dispute_reversal	4
refund	5
dispute	6

.

.

.

[wdavis]

Hi @Danilo9017 

The attached workflow with your data should get you to what you need. Exactly as @Felipe_Ribeir0 has mentioned, if there is a defined order for your output then you can just update the text input if that ever changes to match your own Record ID.

You just need to point the workflow to the folder you have the input saved in and should see the correct output.

[Danilo9017]

Thanks to all for your reply !! and sorry for the delay of my answer it works perfectly 

Danilo

[DenisZ]

To order in the order you want you can use the same way that has been shown above. If my data initially is in the correct order and changes througout the workflow, you could add a RecordID at the start of the workflow just to keep track of the changes and then at the end just sort by RecordID.