Sorting 2 Arrays

[splee]

I have two 1D array of same size, the elements are not in ascending/descending order:

Array#1 [3.5    5.1    4.2    6.2    5.4]

Array#2 [2.1    3.1    4.0    3.5    4.3]

I want to be able to sort the two arrays (in either ascending or descending order) base on one of the array, i.e if sort ascending based on Array#1, the results would be:

Array#1 [3.5    4.2    5.1    5.4    6.2]  <-- this array is sorted (ascending order)

Array#2 [2.1    4.0    3.1    4.3    3.5]  <-- this is not sorted, but the order is such that its elements still correspond to the same element in Array#1

..just like in Excel, you highlight two column, and click the "sort Ascending" button.

How to do this in LV?

[RavensFan · Accepted solution]

Combine your two arrays into an array of clusters where the first element of the cluster is from the first array, and the 2nd element from the second array.  There is a function in the cluster palette called Index and Bundle Cluster Array that will do that for you.

Then sort the 1-D array of clusters.  It will sort based on the first element.

To add more data, do the same thing and append the 2nd array of clusters to the first and repeat the sort.

[splee]

so simple 

[splee]

Anyone has any idea how to convert the sorted array of clusters back to two separate arrays?

---

@Ravens Fan wrote:

Combine your two arrays into an array of clusters where the first element of the cluster is from the first array, and the 2nd element from the second array.  There is a function in the cluster palette called Index and Bundle Cluster Array that will do that for you.

Then sort the 1-D array of clusters.  It will sort based on the first element.

To add more data, do the same thing and append the 2nd array of clusters to the first and repeat the sort.

---

[RavensFan]

Iterate through the array to unbundle the elements back into individual arrays.

 

Then go and kudo this idea.  Why is there no function to reverse "Index & Bundle Cluster Array"