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
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
About Author
Name
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Stay Updated
Get stories of change makers and innovators from the startup ecosystem in your inbox