Searching from excel file

[GerdW]

Hi sam,

you already know how to do that:

1. Filter columns C, D and J

2. Then filter all rows where D&J fit your requirements.

3. Use the remaining elements from column C.

[sam67]

---

@GerdW  작성:

Hi sam,

you already know how to do that:

1. Filter columns C, D and J

2. Then filter all rows where D&J fit your requirements.

3. Use the remaining elements from column C.

---

ji GerdW, i applied what you said according to my understanding, but i didnt get accurate result which i want. They just give me within range number. Here is my VI and front of VI picture.

[GerdW]

Hi sam,

 i didnt get accurate result which i want. They just give me within range number. Here is my VI and front of VI picture.

Because YOU have it programmed this way!

I wrote:

2. Then filter all rows where D&J fit your requirements.

But you filtered ALL columns by their value, not just column D&J…

You only need to filter/keep those rows, where your filter criteria is fulfilled. And you only want to apply a filter on column D&J, but not on column C…

[sam67]

---

@GerdW  작성:

---

Hi GerdW,

I need one more help, in the image i circled one while loop which is inside the one more while loop. I want that when the outer while loop run then the inner while loop run once and when 2nd time the outer loop run then the inner loop run again 2nd time. Like outer loop run and inner loop take just one value and if condition is false then again outer loop run and inner loop give one value again for further procedure. Let me know if you have any confusion. 

[GerdW]

Hi Sam,

I want that when the outer while loop run then the inner while loop run once and when 2nd time the outer loop run then the inner loop run again 2nd time.

When you have code, which should run just once, then you don't need a loop at all!

(Place the shift register at the outer loop and remove the inner loop…)

[sam67]

Then how i used the value for further use inside the outer loop? Because in this case i need the inner loop value one by one by outer loop execution. For example when outer loop run inner loop give just one value and the process complete when the outer loop run 2nd time then inner loop provide again just one next value for further execution. Now in my VI it provide all values at a time and store that value.

[GerdW]

Hi Sam,

For example when outer loop run inner loop give just one value

Maybe you need to explain your problem better…

You asked how to run your code just once and now (I guess) you want that inner loop to run/iterate several times!?

What exactly is the problem? What are you expecting from your code?

[sam67]

You asked how to run your code just once and now (I guess) you want that inner loop to run/iterate several times!?

---

Hi GerdW, yes exactly that's i am trying to explain. Inner loop run several times.

[GerdW]

Hi Sam,

I want that when the outer while loop run then the inner while loop run once and when 2nd time the outer loop run then the inner loop run again 2nd time.

Your code does that already. (Thanks to THINK DATAFLOW!)

Again: What is the problem?

[sam67]

---

Your code does that already. (Thanks to THINK DATAFLOW!)

Again: What is the problem?

---

Hi GerdW, currently it give me all data simultaneously, but i need data one by one for example it give one value first it complete and 2nd second value then 3rd like this but currently it gives all values at the time and the further code take just last value.