2D array search

[ironaaron]

I had 2D array, this array column 1 represent year. Column 2 represent profit.

How to use for loop to search input year then find profit

ex: input    2012

      output  0.4

[GerdW]

Hi Aaron,

convert the 2D array of 2 columns into an array of points, then use the Interpolate1DArray function!

(No FOR loop needed.)

[ironaaron]

tks a lots interesting method

bcz i had three clusters need searching

two input(Stock number, year) get one output(profit)

now I'm stuck with how to use while loop to get output

[GerdW]

Hi Aaron,

---

@ironaaron wrote:

bcz i had three clusters need searching

---

• Why did your requirement changed from 1st to 2nd post?
• Why is the "Stock number" input a float when the value in the cluster is an integer?
• Why do you ask for a WHILE loop when your image only shows a FOR loop?
• Why do you show just images of code instead of attaching REAL code? (We cannot debug/edit/run images with LabVIEW.)

---

@ironaaron wrote:

two input(Stock number, year) get one output(profit)

now I'm stuck with how to use while loop to get output

---

1. At first a loop will select the correct cluster, based on the stock number.
2. Then you can apply my previous suggestion on the 2D array inside the cluster…

[ironaaron]

wanna searching like 

when input1(stock number):2819, input2(year): 2010, then get output(profit):0.64

never searching for cluster so I'm stuck in this issue now

[GerdW]

Hi Aaron,

you still don't provide an example VI.

I still cannot edit/debug/run images with LabVIEW (see my previous message) and I don't want to recreate your array of clusters "manually"…

(Take care of my signature line.)

I can also provide images of code:

[ironaaron]

this my code tks your patient for wait me asking question

first time suffering cluster, so can't figure out

[ironaaron]

when stock:8299

           year:2018

still can't recieve my ideal profit(output):2.988

please help me to debu thanks a lot

[GerdW · Accepted solution]

Hi Aaron,

---

@ironaaron wrote:

when stock:8299

           year:2018

still can't recieve my ideal profit(output):2.988

---

Because you don't read the LabVIEW help for the used functions!

Please read the help for Interpolate1DArray, it mentions an important requirement for the arrangement of your data! (See the "Note!" at the end of the help article.)

Then re-arrange your data to fit this requirement…

[ironaaron]

ignore this crucial note, sincerely my fault

Thank you for patiently answering my questions.