Finding the value when the filler is not giving the exact value

[niks9792]

Hi,

       In this case, both will have the similar effect. Since I need the efficiency to be in between that only and I don't care whether it's interpolating between 14.5-16 or 15-16.

[niks9792]

Hi, 

      This is the modified table. I just need to move the slider and whatever value is coming, it should be compared with the flow value in the table. If the value is there in the table, I need to find some values and one of them is efficiency. If the value is not there, I need to find the efficiency with the values which is nearby the entered value in the table. I cannot sort the flow values. It should be kept like that only. Any sort of inputs is appreciated.

[GerdW · Accepted solution]

Hi niks,

a suggestion to search that "flow" column:

The "row" output will give you an index you can use to get the corresponding values for the other columns. Get values for "row" and "row+1" to apply linear scaling with them to get your "values nearby"…

[niks9792]

Hi,

      Thanks for the solution. But what if the value comes in the slider is 372. How will it check? And can you send me the VI file since I'm not able to find some in Labview 2011, which I'm using.

[GerdW]

Hi niks,

But what if the value comes in the slider is 372. How will it check?

With an input value of "372" you should find the row 30, where the flow values are given as 372.57 (and 371.22 for the next row).

General comment: Your data quality is rather bad, as there are other possibilities to find suitable ranges/rows in your database.csv, like rows 34, 36, 37, 40, 41. So there are 6 possible solutions for your request…

And can you send me the VI file since I'm not able to find some in Matlab 2011, which I'm using.

I'm sorry, but I didn't save the VI after posting.

You need to recreate it from scratch - which I (intentionally) did so you ca learn how to use LabVIEW. (It's a rather small image I posted in the previous message.)

Why do you mention "Matlab" when you want to solve this in LabVIEW?

[niks9792]

Hi,

     thanks for the solution 🙂 . I changed that Matlab, which was unintentional. I will try to solve this. Still if I have any doubts, I will post here.