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:

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:

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:

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:

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

Offset

Use the 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:

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

Set this to 0 if you do not want to use an offset.

Row IDs

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

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

Sorted By

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 ascending or descending to indicate the sort direction. The sort fields do not need to be included in the record view output. 

For example:

fieldnames
Area
Marital Status
cells
0,0,-1
limit
1000
offset
0
rowids true
sortedby
Account Profit
descending
Customer Profit
ascending
Gender
ascending