Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I have a a simple table with these fields :
First Name Last Name Priority
The Priority field is Hight Medium Low
I need to do sorting with Priority but how to display like High first Medium Second and Low Third
Example :
Name Last Name Priority
X Y Hight
Z N Medium
N H Low
Thanks for answer
Create an inline table :
load * inline [
Priority, PriorityId
High, 3
Medium, 2
Low, 1
];
and sort ur table by expression; put as an expression : PriorityId desc
Hello,
I find a solution but i don't know if it's correct but i tried it for many examples and it works...
In the sorting column i added this like an expression :
Priority='High' or Priority = 'Medium'
Thanks
Create an inline table :
load * inline [
Priority, PriorityId
High, 3
Medium, 2
Low, 1
];
and sort ur table by expression; put as an expression : PriorityId desc