I want sort type by condition as below (now sort type by A-Z).data.xlsx (11.7 KB)
step 1 Bring row change type before new type
step 2. Bring row change sim type after fore new type
step 3 Bring type after change sim type until end row to first row.
please guide me about it. @Hiba_B
@balupad14 How​ to​ condition​ in​ sorting?
Hi @fairymemay !
Sure, here is a suggestion: Sort_specific_order_one_column.xaml (12.1 KB)
As it relies on a specific order that has a business logic, you can whenever you want change the order here:
@Hiba_B @prasath17 From output your flow.
I want to move red text to top row (row2)
Step filter as below.
data filter.xlsx (11.4 KB)
Please guide me more.
@fairymemay - you are looking for custom sort …where first Reconnect, then Re New and then Suspend is that right?
@prasath17 yes, Reconnect, then Re New and then Suspend ( sort alphabet R to Z to first).
@fairymemay - @Hiba_B has already provided the solution…isn’t it?
Hi @fairymemay
Sorry for the wait, here is a suggestion:
Sort_specific_order_one_column.xaml (9.7 KB)
As you have a very specific column order, you will have to specify each type of them, like the following:
If the robot get one type that has not been specified, it disappears in the output. If you want a specific treatment for these values, let us know !
@Hiba_B If I don’t want specify name type because some time have more type but I want sort as below.
Any idea?
This is a perfect explanation of your need !!
This will help me to do something better, I will let you know
@Hiba_B I​t​’s​ perfect​ explanation.
If​ sort​ by​ upper I​ show​ you.
I​ think​ it​ perfect.
Please​ guide​ me.
Hi @fairymemay !
Sorry for the delay, here is a suggestion:
Sort_with_queries.xaml (15.3 KB)
Don’t forget to modify the read and write range so it fits to your computer needs !
Let us know if it does not work as expected
Hi @jackyjoy123 !
Do you also need to filter with a specific rule of range letters ?
Or do you have a specific case in mind we might help you on ?
