Technical data

110 Agilent 6200 Series TOF and 6500 Series Q-TOF LC/MS System Concepts Guide
4 Data Acquisition
Worklist import
Mapping for dynamic worklist columns
Some columns in a worklist are dynamic and change from
analysis to analysis. The mapping capability in the csv file lets
you specify additional columns to be added to the worklist. The
name of the added worklist column should use the same name
as the csv column specified. You then specify the column type in
the worklist, such as Compound, Mass, MS Parameter, User
Defined or Custom Parameter. These new columns to be added
to the worklist come under the heading, Dynamic Mapping, in
the mapping section of the csv file.
Data Value mapping Data values for some columns, such as
sample type, are limited to a drop-down list in the worklist and
do not match the same names as are in the csv file. Data value
mapping is preceded by the key words [Data Value Mapping]
Example mapping section
You want to import samples into a TOF or Q-TOF worklist, but
the column headers in the CSV import file (Excel spreadsheet)
are different from the worklist column headers. For example,
“Sample” is used instead of “Sample Name”, as shown below:
One column header, “InternalStdA”, must be added as a new
column to the worklist. You can also add columns that do not
exist in the csv file, such as “Caffeine” in the section below.
Some data values are also different (e.g., Sample Type values).
Table 12 is the mapping section for the spreadsheet in Table 11.
This is the spreadsheet version of the mapping that lets the
worklist import program recognize columns of imported data.
Table 11 Original sample table
Sample Acq
Method
MyData DA SampPos Sample Type Internal
Std A
AAA method1 qwwq method1 1 Standard 1
BBB method2 bbb method1 2 Sample 1
CCC method3 ccc method1 3 QualControl 1