question

Hello @sachin T3,

Using @Jason Lightfoot model I made the following script that takes the array from each cell in the table and sort the array in ascending order.

This is done by pulling the array from the table into a array variable.

The array variable is first queried and sorted in ascending order and then the table that results from that query is queried again to aggregate into an array.

The results are then copied back into the cell of the original array.

Array TempArray;
 
for(int i = 1; i <= Table("GlobalTable1").numRows; i++){
   TempArray = Table("GlobalTable1")[i]["Path"];
   Table results = Table.query("SELECT ARRAY_AGG(number) FROM (SELECT $2 AS number FROM $1 ORDER BY number ASC)", TempArray.length, TempArray[$iter(1)]);
   Table("GlobalTable1")[i]["Path"] = results[1][1];
}