Cross Reference Table to turn operator id number into name
We have a tag with the numeric employee number of the operator on the machine. We have a simple table (e.g. Excel file) with columns for that number and the employee name. We would like to have a tag with the employee name. I know one way of handling this would be a calculation in Canary using the switch function but then as new employees are added, that calculation has to be updated. I'm not sure that's a problem but just wondering if there might be a better recommendation for handling something like this.
6 replies
-
Perhaps consume a csv file using the CSV Collector that would have that information?
-
Do the names need to be historized? If not, you could use embedded "if" statements within an Axiom application using the ValueTransform property of a ValueBox. Therein, it's only available within that particular application. If you need it elsewhere, creating the calc is probably a better option.
Print this page