How To Use GET And GETGROUP Functions In SCIEX OS Software

For research use only. Not for use in diagnostic procedures.

Answer

The calculated columns section in the processing method in SCIEX OS software has two useful functions: 1) GET and 2) GETGROUP. Their purpose is to pull values for a specific analyte or a transition from a group, respectively, for quick and easy comparison in the results table or for further calculations.

To use the GET function, open a processing method in the Analytics mode and navigate to the Calculated Columns tab. Select GET and use following syntax:.
GET([Result-Table-Column];'Component-Name')

For instance, the following syntax will pull the accuracy of the PFOS-1 component:
GET([Accuracy];'PFOS-1')

To use the GETGROUP function, select GETGROUP and use following syntax where n is the number of the transitions in the group:
GETGROUP([Result-Table-Column];n)

For instance, the following syntax will pull the accuracy of the second transition in every group:
GETGROUP([Accuracy];2)