Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is anyone have idea how to sort customly.Like I have month names and I want to sort like January,February etc.
How to sort like this??
You can create an inline table in the script like:
Load * Inline [
Month, Num
Jan, 1
Feb, 2
.....
];
and then use Num field in the front end for sorting expression.
Or, in the front end can use sort expression like:
=Match( MonthField, 'Jan', 'Feb', .....)
You can create an inline table in the script like:
Load * Inline [
Month, Num
Jan, 1
Feb, 2
.....
];
and then use Num field in the front end for sorting expression.
Or, in the front end can use sort expression like:
=Match( MonthField, 'Jan', 'Feb', .....)
in sort tab of any object for expression side write
dual(if(match(Monthname,'January',1,if(match(Monthname,'February',2)) like this way
and if you want to do it on script side then load from inline and make it value like
Monthname,Value
January,1
February,2
etc
Thanks....its working...!!!