Reordering Rows

[ebledsoe22]

Hello. I have a specific order for my rows that goes beyond ascension/descension. Am I able to manipulate the row order within Alteryx?

[Felipe_Ribeir0]

Hi @ebledsoe22 

Could you provide some example of the data before/after the expected row order?

[IraWatt]

Hey @ebledsoe22,

Typically to order a row with some logic you would create a column with the logic then order ascending or descending by that. Or if you have a file in an order you like you could add a record ID and join that onto your data then sort on that record ID. Do you have an example of what you're trying to archive?

[ebledsoe22]

Hello. Sorry for the late reply. I had to step away. Below is current order of rows:

The Order I need the rows to be in:

There isn't a rhyme or reason to the order, but a preference imposed by management for consistency purposes. Is there a way for me to reorder the rows the simple way that we reorder the columns?

[DanFlint]

@ebledsoe22You aren't able to manipulate the row order as you can columns in a select tool.

However, could you use the data in your second image as a lookup to order the fields?

Using a lookup with a RecordID tool, joining it to the main data and using a sort can order the rows to your preference: