Hi guys,
I was trying to restructure rows to columns. I used PIVOT stage but was not getting the results I want.
This is what I tried to do.
SOURCE contains 5 cols in a csv file (see below)
Val1 VAl2 Val3 Val4
ID 1 2 3 4
DESC A B C D
Expected Result: 2 columns: ID and DESC (see below)
ID DESC
1 A
2 B
3 C
4 D
How can I do this??
thx,
Agggie
transpose records
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom