can i transpose with a resident

[fdelacal]

Hello Community. i Explain my problem.

Table1:

load

     field1
     field2
     field3
from

1.xls

Table2:

load *

resident Table1

Transpose();

It,s that be possible???

Thanks

[jagannalla]

Hi,

Table1:

Load

Key,

Field1,

Field2,

Field3

From Table1.xls;

Table2:

CrossTable(Dim,Value)

Load * resident Table1;

Based on  Key column two tables will link.

Go to help in the file:

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 crosstable prefix.

The syntax is:

crosstable (attribute field , data field [ , n ] ) ( loadstatement | selectstatement )

where:

attribute field is the field to contain the attribute values.

data field 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.

Examples:

Crosstable (Month, Sales) Load * from ex1.csv;

Crosstable (Month,Sales,2) Load * from ex2.csv;

Crosstable (A,B) Select * from table3;

Cheers!!

Jagan Nalla