Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone ,
I want to implement custom sort on country. i have already tried below two approaches
1. Sort expression match(Country, 'Sweden', 'Denmark', 'Norway', 'Others')
2. in Script creating n inline table
CountrySort:
MAPPING Load * inline [
"Country " , Sort
Denmark,2
Sweden,1
Norwary,3
Other,4
];
Dual("Country ",Applymap('CountrySort',"Country ")) as "Country"
both gives me wrong order.
Any suggestions
Actually it worked when i unchecked all sort options even expression