How to use crosstable but not contain ID column?

[Anonymous]

After loading a table from .CSV,I want to use crosstable function on it. And I want to crosstable all the column but ID,how can I do simply?

For example,

ID A B C
1 A1 B1 C1
2 A2 B2 C2
3 A3 B3 C3

after crosstable=>
ID Field Value
1 A A1
2 A A2
3 A A3
1 B B1
2 B B2
3 B B3
1 C C1
2 C C2
3 C C3

but I want to crosstable all the column but ID,like this

Field Value
A A1
A A2
A A3
B B1
B B2
B B3
C C1
C C2
C C3

Is there any simple way to achieve?

[maneshkhottcpl · Accepted solution]

Hi,

Use the following script,

AA:
LOAD * INLINE [
ID, A, B, C
1,A1, B1, C1
2, A2, B2, C2
3, A3, B3, C3
];
BB:
Crosstable (Ax,Bx,1) load * resident AA;
drop field ID;
drop table AA;

u can dro a field after the reload.

[Anonymous]

Manesh replied on Wed, Jan 5 2011 9:46 PM

Thank you for your idea,Manesh. "Drop Field" is what I want.