Selective Excel data using true/false case on LV

[LJM1017]

Hi Everyone!

Thank you for taking time to click on this question.

I am wondering how to graph specific rows of data from specific columns and use the true or false case to select which data in the array is displayed on the graph. 

I have attached a sample excel file.

Column C is comprised of values of 0 and 1, where I only want the values from the rows where there is a value of 1 in column C.

I plan to graph Column A against Column B only with the rows where Column C has the value of 1.

Thank you so much!

[GerdW]

Hi LJM,

---

@LJM1017 wrote:

I plan to graph Column A against Column B only with the rows where Column C has the value of 1.

---

Simple steps:

1. Read the data from your Excel file using RGT functions. (I recommend to convert the file into a CSV file, then your VI will be much simpler.)
2. Filter your data using the 3rd column as condition: a FOR loop with a conditional output tunnel will make this very easy!
3. Create a plot from 1st and 2nd column…

What have you tried? Where are you stuck?

[LJM1017]

Thank you very much for the response!

I still don't fully understand the lingo as this is my first time ever programming let alone understanding what each one means. I have been able to do the very basics such as graphing and creating arrays. However, in cases like these, I cannot even begin.

I am also a visual learner and there are not many helpful specific things on youtube

The LabView community has been nothing but helpful however.

[LJM1017]

Here is an image of what I understand but it is wrong since I cannot even run the CSV file.

[GerdW]

Hi LJM,

---

@LJM1017 wrote:

Here is an image of what I understand but it is wrong since I cannot even run the CSV file.

---

How do you "run a CSV file"? It's just text, which you can read…

(Why do you attach an image of code when you could attach the real code?)

See this: