Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
Manesh replied on Wed, Jan 5 2011 9:46 PM
Thank you for your idea,Manesh. "Drop Field" is what I want.