I have a table with data from multiple machines, and want to update the last row of the table for a particular machine with a group. I tried creating an sql tag called “A055_Down_Last_ndx” with the following expression:
SELECT max(ndx)from Machine_Data where (Machine_Name)=‘A055’
The idea was to find the last index for that machine, however I get an error for this tag and a null value.
Then I was planning on using the custom option in the table update/select, and entering the following in the field:
Any suggestions on better methods would be appreciated.