Multiple cols - how to use sort tool

[SrinivasanSugumaran]

HI team ,

I need to sort 2 cols. (both name and month are to be sorted in descending) and I am stuck in a workflow using sorting tool. Appreciate if you can help. Tried the sort tool but only the first col . is sorted correctly.

Name	Month	Salary
a	jul	1
b	dec	2
a	jan	3
b	sep	4

expected output:

Name	Month	Salary
b	dec	2
b	sep	4
a	jul	1
a	jan	3

[Emil_Kos]

Hi @SrinivasanSugumaran,

You need to change the month to date format to make it work for you:

[SrinivasanSugumaran]

Hi Emil

Thanks for the reply.

The columns which I have are kind of dummy cols ...

In the actual data set I have 2 cols. with data type as Double. but it didn't work out.

Col. Avg RW is already sorted, but SUM RWA GBP is not .

Avg_AVERAGE RW	Sum_EAD GBP	Sum_RWA GBP
12.5	0.87568	10.95
12.5	21749.89	271,873.66
12.5	74.90395	936.30
12.5	9.864941	123.31

[Emil_Kos · Accepted solution]

Hi @SrinivasanSugumaran,

Are you sure they are duble? I needed to remove the , sign in order to change the data type correctly:

I have used this formula to make it work:

Replace([ Sum_RWA GBP ], ',', '')

[SrinivasanSugumaran]

thanks emil..

It worked.