Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have data , I want rank each dimension by group the values .
abcd:
Load *
Inline [
Name,City,State
Ab,Hyd,Ts
Ab,Hyd,Ts
Ab,Mum,Mh
Cd,Mum,Mh
Cd,Mum,Mh
Xy,Kol,Bg
];
I got output
Name | Rank for Name | City | City rank |
Ab | 1 | Hyd | 1-2 |
Ab | - | Hyd | 1-2 |
Ab | - | Mum | 1 |
Cd | 1 | Mum | 1 |
Cd | - | Mum | 1-2 |
Xy | 1 | Kol | |
Expecting output:
Name | Rank for Name | City | Rank for City | State | Rank for State |
Ab | 1 | Hyd | 1 | Ts | 1 |
Ab | - | Hyd | - | Ts | - |
Ab | - | Mum | 1 | Mh | 1 |
Cd | 1 | Mum | 1 | Mh | 1 |
Cd | - | Mum | Mh | - | |
Xy | 1 | Kol | 1 | Wg | 1 |
You can try this:
Add this to the loadscript:
Load *, rowno() as row
And for the ranking expressions:
aggr(rank(-row), Name, row)
aggr(rank(-row), Name, City, row)
aggr(rank(-row), Name, City, State, row)
You can try this:
Add this to the loadscript:
Load *, rowno() as row
And for the ranking expressions:
aggr(rank(-row), Name, row)
aggr(rank(-row), Name, City, row)
aggr(rank(-row), Name, City, State, row)