Record View

You can activate record view output by setting EnableRVOutputCSV to 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:

CODE

fieldnames
<list of columns to include in record output, one per line>
cells
<row>,<column>,<wafer>
limit
<limit>
offset
<offset>
rowids {true|false}
sortedby
<field>
{ascending|descending}

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 fieldnames and 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.

For example:

CODE

fieldnames
Area
Marital Status
Occupation
Age
Customer Mail Indicator

Cells

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 -1.

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:

CODE

fieldnames
Area
Marital Status
cells
0,0,-1

Limit

Use the limit section to specify a limit on the number of records returned. For example, the following configuration returns only the first 1,000 records:

CODE

fieldnames
Area
Marital Status
cells
0,0,-1
limit
1000

Row IDs

Add the rowids parameter set to true to configure record view output to include the record row ID. For example:

CODE

fieldnames
Area
Marital Status
cells
0,0,-1
limit
1000
offset
0
rowids true