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 " , SortDenmark,2Sweden,1Norwary,3Other,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