LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

sort a file having three colomn such that I can get the maximum value in the third colomn and its corresponding value in first and second colomn. Plz help

I need to read a file which is having three colomns..position X, Position Y and voltage respectively. I want to sort the file such that I get the maximum voltage value and its corresponding position X and Position Y. Please help
0 Kudos
Message 1 of 3
(2,499 Views)
Use Read From Spreadsheet File to get a 2D array. On the 2D array use index array to get the voltage column (column 2). On that array, use Array Max & Min to return the max value and the index value. Use the index value to get the data from columns 0 and 1 with two more Index Array functions.
Message 2 of 3
(2,499 Views)
Thanks Dennis for such a fast and smart answer.

-Jalan
0 Kudos
Message 3 of 3
(2,499 Views)