Cross Table Load

Cross Table Load

A cross table is a common type of table featuring a matrix of values between two or more orthogonal lists of header data, of which one is used as columnd headers. A typical example could be to have one column per month. To transform a cross table into a straight table, use a crosstable prefix. The result is that the column headers (e.g. month names) will be stored in one field – the attribute field – and the column data (month numbers) will be stored in a
second field: the data field.

The syntax is:
crosstable (attribute field name, data field name [ , n ] ) ( load statement | select statement )
where:
Attribute field name is the field to contain the attribute values.

Data field name is the field to contain the data values.
n is the number of qualifier fields preceding the table to be transformed to generic form. Default is 1

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Cross Table Load"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please leave a message and we'll get back to you soon.

    3 + 5