The left hand side of the Main worksheet assist you in defining and creating meaningful column header of the CSV data sheet which is selected on the worksheet.
The
left side has four functions:
Lists the actual column headers, their column
number and letter, and offers the possibility to enter a new description. The
column number and letters are very important when you create charts from the
data.
Shows a drop-down list with pre-defined
headers for a set of reports of the z/OS AVTEST tool kit. If you use such a
report, select the corresponding list entry and press the
button. The new column description are now
copied into the “New Description” column of table
.
The
button allows you to copy the current column
headers from the CSV data sheet to the “Description” column of the Main
worksheet. This is most important whenever you manipulated the CSV data sheet
directly or when you have created new data columns on the data sheet.
In
order to populate the “New Descriptions” to the CSV data sheet, press
.
The new description is then copied onto the CSV data sheet column headers and
the Description column to the right. The “New Description” column is cleared
with this action.
The example below depicts how the column header of a CSV
report can be renamed. In the beginning the column header on the CSV data file show “Intv, MM/DD/YY, HH:MM:SS, …” and
the same is shown in the “Description” column
on the Main worksheet. The next step is to
enter new description in the “New Description” column, for example: “Interval,
Date, Time, System, etc …”.
After pressing the
button the new column header are populated to
the CSV data sheet
and to the “Description” column on the main
worksheet. The “New Description” column is cleared. By comparing the CSV data
sheet column header and the “Description” column we see the same entries again
.
It is also assumed that the column header of all CSV sheets are always located
in the second row of the data sheet. The first row is usually empty but it may
contain management information, like the number of rows on the data sheet
(always cell C1). At the third row the data table starts.