Forum

Sorting Text based ...
 
Notifications
Clear all

Sorting Text based on text in another field

2 Posts
2 Users
0 Reactions
126 Views
(@barbsm)
Posts: 2
Active Member
Topic starter
 

PQ_sortingproblem.PNGHi

I have used your sort order conditional column to help with sorting my data - thanks very helpful.

However, in my data it is putting two of the same values one after the other and I need it in a more custom sort order

I have trainings courses in my list that I want listed under the relevant Overview course for that subject, but I don't know how to automate that. I am attaching what have done already in the Power Query and a screenshot of what I mean. 

Is there a way of automating this? The Overview course usually starts with the same name as the general course I require after it, e.g.

Tender Management Overview

Tender Management

Pricing Managment Overview

Pricing Management

The other order is working fine. 1-5 

Thanks Barbara

 
Posted : 30/09/2023 1:51 pm
Philip Treacy
(@philipt)
Posts: 1631
Member Admin
 

Hi Barbara,

The Sort_By column is created based on your logic and the contents of the Sorter column.  So if you want things sorted differently you need to modify either, or both.

That said, looking at the code for the Sort_By column you have a line that says if the Course Title contains the text "RB" then 6 - but "RB" only appears in the Sorter column.

If you want Tender Management to appear after Tender Management Overview then you need to rewrite your Conditional Column code to assign appropriate Sort_By values for each of these.

Regards

Phil

 
Posted : 06/10/2023 3:10 am
Share: