Crosstable question

[russell_angus]

I have a table in excel which has one dimension as the rows, and another dimension as the columns. The data values are all either true or false.

E.g.

          Dim2

Dim1     X     Y     Z     and so on...

A         T     F     F

B          F     T     F

C         F     T     T

and so on...

So far so good...

When I use the crosstable function in the load statement it includes the first column header as one of the data values, in my example above the X.

What I want is:

Dim1     Dim2     Data

A          X          T

A          Y          F

A          Z          F

etc

Can anyone help?

[kaushiknsolanki]

Hi,

     Try this way.

DATA:
Load * inline [
Dim1,X,Y,Z
A,T,F,F
B,F,T,F
C,F,T,T
];

CrossTable (Dim2,Value,1)
Load Dim1,
  X,
  Y,
  Z
Resident DATA; 

Regards,

Kaushik Solanki

[#3]

Temp:
Load * inline [
Dim1,X,Y,Z
A,T,F,F
B,F,T,F
C,F,T,T
];

CrossTable (Dim2,Value,1)
Load Dim1,
  X,
  Y,
  Z
Resident Temp; 

[er_mohit]

see the attached file

output this

Dim1	Dim2	Data
A	X	T
A	Y	F
A	Z	F
B	X	F
B	Y	T
B	Z	F
C	X	F
C	Y	T
C	Z	T