0
![](https://s3-us-west-2.amazonaws.com/media.forumbee.com/avatar/861bd75fe759018ee33e5661417e6c03-1631372758000/h/40.jpg)
Forum / Questions & Answers
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.
Like
Follow
6replies