How to get second, third, etc largest values in an array using Arcade?

RezaTehranifar2

I am trying to create a popup using arcade that shows in descending order the values across four fields in one feature.

for example, 

name	col1	col2	col3	col4	col5
geography A	10	30	5	40	20

I would like to have access to an array (or other data types) that I can use in a popup. The user would click on a feature on the popup would show the following:

1. $feature.col4

2. $feature.col2

3. $feature.col5

4. $feature.col1

5, $feature.col3

I have less of an issue presenting in popup, but getting the data ordered. I dont think there is a slice or filter available in arcade.

There is OrderBy function, but that goes down a column vs across a row

so far I have the following in my code to get the max value

var col1 = $feature.col1

var col2 = $feature.col2

var col3 = $feature.col3

var col4 = $feature.col4

var col5 = $feature.col5

var max_val = (col1, col2,  col3, col4, col5)

My logic tells me that I should remove the current max value and then continue to run max function until I have the last one. But I cant seem to find an easy solution. I can run a long if statement, but hoping there is an easier option.

Thanks

Reza

JoshuaBixby

To expand on Xander Bakker‌'s reply, you could also create a label showing column name and sorted value:

// define Sort comparator returning IsEmpty as least values
function Comp(a,b) { 
    When(
        IsEmpty(a[1]), -1,
        IsEmpty(b[1]), 1,
        IIf(a[1]>b[1],1,-1)
    );
};

// create array of [ColumnName,ColumnValue] arrays and sort on ColumnValue
var arr = [
    ["col1", 10],   // ["col1", $feature.col1],
    ["col2", -30],  // ["col2", $feature.col2],
    ["col3", 5],    // ["col3", $feature.col3],
    ["col4", 40],   // ["col4", $feature.col4],
    ["col5", null], // ["col5", $feature.col5],
];
// arr = Sort(arr, Comp);  // ascending sort
arr = Reverse(Sort(arr, Comp));  // descending sort

// create label showing sorted 'ColumnName : ColumnValue' pairs
var nl = TextFormatting.NewLine;
var lbl = "";
for(var k in arr){
    var i = arr<K>;
    lbl = Concatenate([lbl, Concatenate(i," : ")], nl);
};
return lbl;<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></K>

returns

col4 : 40
col1 : 10
col3 : 5
col2 : -30
col5 : <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>