Rename and maintain column headers

 

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.

Example

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.