08-17-2006 05:03 AM
08-17-2006 10:25 AM
First, the concept. An Access table is functionally identical to an Excel sheet. It is only when adding other tables and relations that Access becomes a DB, so whatever you did before you should also be able to do now. If I understand what you want correctly, this should simply be a matter of indexing column A out of the array, using a Search 1D Array on it and using the index to get your other elements out of the 2D array.
Second, the reading. I don't think that the PDA module has any support for ActiveX yet, so you won't be able to read the Excel spreadsheet either. You will have to save it as a CSV file and then read that file in LV (use the Spreadsheet String to Array VI with a comma as the seperator). Note that if the array gets large, the PDA module might have problems reading or processing it. The same might hold true for the indexing out of column A (which will create a copy of it) and you might need to do some playing around to keep the memory consumption down.
08-23-2006 08:29 AM
I'm unable to solve the problem. I tried to use the answer you suggested: simply a matter of indexing column A out of the array, using a Search Array on it and using the index to get your other elements out of the 2D array.
An example of what you said will be very helpful.
I use a Read from Spreadsheet to read the CSV file and then Insert Into Array VI and then an Indicator. I can see all the values in the indicator, but what I want to do I don't know how.
Just to clarify things again: I want to search the first column (A or 1D array) for value (Preferably a String), if that String is found, get every thing in the Row (either Row has a value for A, B, C and D) should be returned and used to populate 4 String Controls.
I dont know how to use the String control to query the Array or how the Search 1D Array will do this.
Any help please.
08-23-2006 09:28 AM
08-23-2006 09:59 AM
08-23-2006 11:07 AM
Yes, it is. Simply use the Index Array function, resize it to have 4 outputs and create indicators from those outputs. This is really very basic stuff in LV, so I suggest you look at those links to become better acquainted with LV.
I'm guessing it is straight forward to place results that was displayed in 1D Array into 4 Separate String Control?