You can activate record view output by setting
true in the configuration file or on the command line. Production System will output unit records from the SXV4 in CSV format.
By default, the record view output file will:
- Include all records that contribute to the entire table.
- Include only the columns for the records that relate to the fields in the table.
For example, if your table contains Gender by Marital Status then by default record view will list the gender and marital status for every record that contributes to the table.
However, you can change this by creating an additional configuration file. This needs to be saved to the same directory as the TXD file, with the same name as the TXD but the _rv.txt extension. For example, if the TXD is AgeByArea.txd then the record view configuration file must be AgeByArea_rv.txt.
The format of this file is as follows:
These sections are explained in more detail below. All sections except
fieldnames are optional. However, you cannot skip a section (so if you want to set a
limit then you must also include the
cells sections in order).
Columns to Output
To specify the columns you want to output, set the first line in the configuration file to the keyword
fieldnames, followed by the name of each field you want to include in the output in order, with each field name on a separate line.
When the configuration file contains only a
fieldnames section, the Record View output will include all records contributing to the table. If you want to select a specific cell, add a
cells section and specify the cell you want by specifying the row, column and wafer, starting from 0. If an axis does not exist, set it to
For example, the following configuration will return the Area and Marital Status for all records that contribute to the top left cell in a table that has no items on the wafers:
limit section to specify a limit on the number of records returned. For example, the following configuration returns only the first 1,000 records:
offset section to specify an offset for record output. If this option is specified then the record output will start after the specified record number.
For example, the following configuration will return 1,000 records, starting at record 1,001:
Set this to
0 if you do not want to use an offset.
rowids parameter set to
true to configure record view output to include the record row ID. For example:
You can optionally add sort conditions by including a
sortedby section at the end of the configuration file. In this section you can provide a list of fields to use to sort the results. Each field needs to be followed by either
descending to indicate the sort direction. The sort fields do not need to be included in the record view output.