Sort the values according category.

Question

I have a variable that contain list of items, items are ;- 
 year , category , value 
 2024, cap internal , 20 
 2024, cap external, 60 
 2024, cap material, 50 
 2025, exp internal , 20 
 2025, exp external , 30 
 2025, exp material , 40 
 I want to sort this like :- 
 year , category , value 
 2024, cap external, 60 
 2024, cap material, 50 
 2024, cap internal , 20 
 2025, exp external , 30 
 2025, exp material , 40 
 2025, exp internal , 20

Stefan Helzle · Answer

Use the todatasubset() function. Find an example here: https://docs.appian.com/suite/help/24.4/fnc_scripting_todatasubset.html#examples

Sort the values according category.

Top Replies