Cross Table

[#1]

HI All,

I have a script which has 42  rows , I took the resident of Branch  and using

CrossTable(PAD_Type,PAD_Description,40) i got the vertical rows with a column name as

PAD_Type and conetename as  PAD_Description,

Now my question is , suppose i need to convert the row number 12 and give it as a name Cass and Row number 13 as the content of the Class

how do i writ this in cross table ?

[#2]

Hi

Please check this

Read the concepts of crosstable.

Crosstable

A cross table is a common type of table featuring a matrix of values between two orthogonal lists of header data. To turn a cross table into a straight table, use a cross table prefix.

The syntax is:

crosstable (attribute field , data field ,Qualifier)

Crosstab Wizard

The crosstab wizard is dialog driven method of creating the cross table syntax. This dialog is opened by clicking the Cross Table button in the Options page of the File Wizard. The crosstab wizard holds the following options:

  where:

Qualifier Fields	The number of qualifier fields that precede the fields to be transformed.
Attribute Field	The name of the new field that will contain all the fields (attribute values) to be transformed.
Data Field	The name of the new field that will contain the data of the attribute values.