I have a set of machine values that are writing to a table. I need to add 3 fields to this table: OrderNumber, OrderLineNumber and RollSequence. This data is available via querying another table. Management wants to be able to filter the machine data based on these 3 fields.
I am able to query these fields and display it in PMI but I need to have it written with each row in the machine data table.