Custom excel sorting

Help StudioX
,
1

Hi guys, how can I custom sort by a set of words/list?

Lets say this is my column:

MIR
TIR
TIR
MIR
PIR
CIR

And I would like to have it sorted by: MIR, TIR, PIR, CIR

So after the sort the column would look:

MIR
MIR
TIR
TIR
PIR
CIR

There is no option of custom sort in the studioX in the sort range activity, I’m only allowed to select column and the direction. Pls advise

2

please confirm to us that the question is related to StudioX and not Studio

When StudioX is addressed then please let us know the detail StudioX Version

For Studio we do have approaches for custom sorts
For StudioX we would crosscheck depending to the Version

Thanks

3

StudioX 2022.10.3

4

Hi @marcin.chowaniec ,

dt = dt.Select("",[ColumnName] asc").CopyToDataTable()

Regards,
Arivu

5

Hi,

I’m total noob, I understand that in ColumnName I have to insert the name of a column however: where should I add the command, and where should I specify by what I want to sort the column? :slight_smile: