LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Searching from excel file

Solved!
Go to solution

@GerdW  작성:

Hi Sam,

 

But i need the data which is monotonously rising at the same time

Then you need to apply more than just one condition: "InRange AND Rising"…

 

 


InRange AND Rising? how i should use that condition that only those data store in array which is like this (12 32 43 34 23 23 24 25 24 25 26 25 25 26 26 34 43 32) only red numbers are store in array. any specific example or logic which i try to use. Thanks

0 Kudos
Message 51 of 96
(931 Views)

Hi Sam,

 

you asked for:

currently my code search specific range of data from selected column. … i need the data which is monotonously rising at the same time

in message #48.

 

Now you wonder about my suggestion "InRange AND Rising?"???

 

only those data store in array which is like this (12 32 43 34 23 23 24 25 24 25 26 25 25 26 26 34 43 32) only red numbers are store in array.

Those numbers DON'T FIT your requirement of "InRange AND Rising" as 24 follows 25 and 25 follows after 26…

Please give an example which FITS to your own requirement!

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 52 of 96
(926 Views)

@GerdW  작성:

Hi Sam,

 

you asked for:

currently my code search specific range of data from selected column. … i need the data which is monotonously rising at the same time

in message #48.

 

Now you wonder about my suggestion "InRange AND Rising?"???

 

only those data store in array which is like this (12 32 43 34 23 23 24 25 24 25 26 25 25 26 26 34 43 32) only red numbers are store in array.

Those numbers DON'T FIT your requirement of "InRange AND Rising" as 24 follows 25 and 25 follows after 26…

Please give an example which FITS to your own requirement!


sorry for misunderstanding, i will attach my file in which gfp column data i need and in this column. i need this blue line data. For example data are like this 1 2 33 44 22 44 22 54 76 44 33 22 16 16 16 15 15 16 16 15 16 45  34 2 1 16 15 17 18 43 16 16 15 45 34. But i need just this red line data which is in range and monotonously rising, but all data in specific range if value are above then range or less then range then the code doesn't store any more data.

One more thing maybe data are like this 12 13 14 15 16 16 15 17 18 16 17 169 28 27 161 15 151 161 16 15 17 18 16 15 23 23 43 54 64, in this the range is 14 to 18, but you cane also see that the 2nd red line number also lie in this range, so here first program select those number which has more long range for example first red line has 9 range and 2nd red line has 6 range so program select highest range. Thanks

0 Kudos
Message 53 of 96
(921 Views)

Hi Sam,

 

But i need just this red line data which is in range and monotonously rising,

Your data shown in the message ARE NOT MONOTONOUSLY RISING!

 

Please rethink your requirements and give approriate examples and descriptions!

(When you don't know the mathematical term "monotonously rising" you should read up on Wikipedia…)

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 54 of 96
(918 Views)

@GerdW  작성:

Hi Sam,

 

But i need just this red line data which is in range and monotonously rising,

Your data shown in the message ARE NOT MONOTONOUSLY RISING!


Hi GerdW,

 Sorry once again for misunderstanding. I just say that, if data are rise or decrease after the specific range then its stop to store data in array. Simply, if data are like this (1 2 33 44 22 44 22 54 76 44 33 22 16 16 16 15 15 16 16 15 16 45  34 2 1 16 15 17 18 43 16 16 15 45 34). First algorithm search that where this range has many numbers of digits and then just store that part of data. In the above example the range is 15 to 16, but you can see that there are many indexes where 15 and 16 are present but at the specific place its continuously present. Thanks. If still is not understandable then let me i will try once again.

0 Kudos
Message 55 of 96
(910 Views)

Hi Sam,

 

if data are like this (1 2 33 44 22 44 22 54 76 44 33 22 16 16 16 15 15 16 16 15 16 45  34 2 1 16 15 17 18 43 16 16 15 45 34).

What about those blue and green marked values? Do you also want to use them for your filter result - or not?

And what is the exact condition to choose them or not choose them?

 

In the above example the range is 15 to 16, but you can see that there are many indexes where 15 and 16 are present but at the specific place its continuously present.

In your example string the blue and green numbers are also "continuously present"!

So what is your exact condition to filter values?

 

If still is not understandable then let me i will try once again.

Still not clear for me.

As long as you aren't able to provide a clear description of your requirement you will not get any useful result…

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 56 of 96
(897 Views)

@GerdW  작성:

Hi Sam,

 

if data are like this (1 2 33 44 22 44 22 54 76 44 33 22 16 16 16 15 15 16 16 15 16 45  34 2 1 16 15 17 18 43 16 16 15 45 34).

What about those blue and green marked values? Do you also want to use them for your filter result - or not?

And what is the exact condition to choose them or not choose them?


Hi GerdW, no we don't need these values, if this situation occur, then the algorithm select those values which is more digits as compared to other. For example, if data are like this (1 2 33 44 22 44 22 54 76 44 33 22 16 16 16 15 15 16 16 15 16 45  34 2 1 16 15 17 18 43 16 16 15 15 16 15 45 34). In this red are 9 digits and green are almost 6 digits, so the algorithm make new array in which just 9 digits red values. 

0 Kudos
Message 57 of 96
(892 Views)

So is your rule that you want the longest stretch of values that are in range?

0 Kudos
Message 58 of 96
(890 Views)

@RavensFan  작성:

So is your rule that you want the longest stretch of values that are in range?


Hi RavensFan, Yes.

0 Kudos
Message 59 of 96
(888 Views)

So why did it take 59 messages to get to clarify what you wanted?

 

That is now a clear statement we can work with.

 

0 Kudos
Message 60 of 96
(878 Views)