.
Hi,
Are the numbers you get from your PLC consecutive and integres? E.g., 0, 1, 2, etc.? Or are they non-consecutive and real? E.g., 0.12, 5.78, etc.?
If they are the former, then creating a "lookup" table is pretty easy. Use the DataTable object and enter all the descriptions in the first column. Connect the number coming from the PLC to the cursor.1. This will point to the right row of the DataTable depending on its value.
Next, display the following Expression on the panel for your description: Table1.A.txt.1
That should do it.
If however the numbers are not integers and consecutive, then you'll need to do some more work. Basically the idea being, enter the numbers in the first column of the DataTable object, and the corresponding descrip
tions in the second. Then compare the number from the PLC with the numbers in the first column and lookup the corresponding description.
I am attaching an example of this. In the example, the DataTable is populated with two columns -- one (A) having the original number and the second (B) the corresponding lookup value. Using a Pot, I specify the number to lookup from this table. This Pot can be replaced by your actual PLC number. The example will then search for the Pot value in Column A and then display the corresponding lookup value from Column B. If the number is not found, it returns -1. See the example for implementation details.
The XLS file has the original data which you import into the DataTable (change the location of the file in the DataTable properties). Note that in the example, my second columns are also numbers; you'll change these to txt.
The "Help panel" in the example is well documented.
Hope this helps. Anybody has other and better ideas, please share!
Rgds,
Khalid 🙂
.
