LabVIEW
Check if 1d / 2d array has empty data which is written in delimited spreadsheet
Hi all,
I have a labview vi for an automated test. The last part of it stores the result of each part of the test in an excel spreadsheet. Throughout the vi, I am adding the results (field name and result value) in a 1d array and then sorting it into 2d array with multiple rows and 2 columns in the vi shown below.
With least number of changes, I want to be able to add a feature wherein I can check if the result for any field name is empty or not. For example if the field name is software. Check the column to the right and if the cell is empty then flag it as a fail in the consecutive case structure.
I have added features wherein I am checking for number of rows and columns to make sure no cell is empty. I want to make this feature more robust wherein I am able to check each row and see if the column next to it which contains the result is empty or not.
I want to add this feature in the first part of the horizontal frame so that if I catch for an empty cell, I will be able to store the result document in the fail folder.
Thank you for your reply.
I mean, if I stick to only answering your question, then the answer is just to add in a couple of nodes.
Based on this bit of code:
It looks like you collect 107 data points in an array of 214 strings, with each even-numbered index being the field name of a data point and the odd numbers being the result. Is that the case?
If so, just add in an "Empty string/path?" node on the first half of the Decimate 1D Array output, and check to see if any True results come out.
You can just use the Boolean output of that as another input into your check to see if it fails.
However, there's also a lot of what is generally called a "code smell" that I can see in the small bit of your code that you have posted. A "code smell" doesn't mean "it doesn't work", but rather "this will be a nightmare to debug or maintain". If you have time to "do it right" I would advise looking for more advice.
To start with:
1. Using sequence frames is almost always a sign that you don't understand what "dataflow" is, or you're using things in your code that you probably shouldn't be (usually local variables).
2. Using a single 1D string array to hold everything your program outputs will likely make it very difficult to maintain, meaning if you have to add new data in the middle or look up previous data, you're going to be using a lot of hard-coded index values or string matching with lookups. You might want to consider something like a "Map" data type (where the lookup can just be a string directly) or an array of clusters (where each cluster is a data value/data name pair)
3. You say "I have a VI", making it sound like the entire code is in one VI. Look into making it into subVIs. As a starting point, probably each sequence frame that you have could become its own subVI.
