我需要将多个行组合成一行,原始数据格式如下所示:
RegisterID | IndividualID | DayID | TripID | JourSequence | NoteID | TripPurpose |
---|---|---|---|---|---|---|
408257 | 200100000001 | one | apple | one | orange | aaa |
408257 | 200100000001 | one | apple | two | orange | bbb |
408257 | 200100000001 | one | apple | three | orange | abc |
408257 | 200100000001 | one | apple | four | orange | ccc |
408257 | 200100000001 | one | apple | five | orange | bcd |
408257 | 200100000001 | one | apple | six | orange | eaf |
408359 | 200100000009 | two | apple | one | orange | dfc |
408359 | 200100000009 | two | apple | two | orange | www |
408359 | 200100000009 | two | apple | three | orange | xxx |
408359 | 200100000009 | two | apple | four | orange | yyy |
408359 | 200100000009 | two | apple | five | orange | zzz |
408359 | 200100000009 | two | apple | six | orange | xyz |
我试图将表转换为如下所示:
RegisterID | IndividualID | DayID | TripID | one | two | three | four | five | six |
---|---|---|---|---|---|---|---|---|---|
408257 | 200100000001 | one | apple | aaa | bbb | abc | ccc | bcd | eaf |
408359 | 200100000009 | two | apple | dfc | www | xxx | yyy | zzz | xyz |
请问解决方案是什么?我试过pivot,但是老是报错。
相似问题