Filtering a 2d array(x and y) based on data in y column

[Pa1_korea]

Hii Friends,

Can anyone help me with the following problem.

I have a two columns ( say p and s) as in the excel file consisting of 408 rows.

I need to delete those values in the s column which are above 0.005. When i delete this value, the corresponding p value should also be deleted.

I have made a part of the labview code that accepts the .csv file and tried using the 'Inrange function for filtering action.

However, the output file always returns me the original input file.

Can anyone lemme know what i am doing wrong here.

I am using LV2013. Attaching both excel and VI files.

Thanking you.

[Jimbe]

Hello Pa1_korea!

As I can see in your VI, You are only comparing (in range) the first value on your Array (zero row). There is no way (on your code) that you can compare the values of the rest of the rows.

How can you solve that? Putting that section on a while or for cicle in order to index all the rows. 

Moreover, You need to set the value of the upper limit as 0.005 and the lower as the minimum value you want.

Finally, Try to correct the best data value on the indicators and controls. For example, For the index of the array, is better to put an Integer than a double.

Regards.

[Gregory]

Can you paste a snippet or upload a LV 2012 version?

[jamiva · Accepted solution]

Pa1_korea wrote:

Hii Friends,

Can anyone help me with the following problem.

I have a two columns ( say p and s) as in the excel file consisting of 408 rows.

I need to delete those values in the s column which are above 0.005. When i delete this value, the corresponding p value should also be deleted.

I have made a part of the labview code that accepts the .csv file and tried using the 'Inrange function for filtering action.

However, the output file always returns me the original input file.

Can anyone lemme know what i am doing wrong here.

I am using LV2013. Attaching both excel and VI files.

Thanking you.

---

It's a lot easier using a conditional tunnel than doing it your way using an "In Range" function.

[aputman · Accepted solution]

You could also do it like this where you only do the comparison one time and then build the conditional array afterwards.  Computationally, it is probably the same as what jamiva posted but this seems a bit cleaner to me.  Opinions....noses.

[Pa1_korea]

Thanks a trillion aputman....The code worked..

[Pa1_korea]

Thanks a lot Jamiva..the code worked.....