sunniar

How to merge two records

Discussion created by sunniar on Jan 17, 2016
Latest reply on Jan 21, 2016 by sunniar

The database structure as follow

UID               position               B               P

123               head                    1.9               0.9

123               tail                         1.88              0.91

456               tail                         1.87               1.02

456               head                       1.91               0.89

 

And i want to merge the records like below:

 

UID               B_head          P_head          B_tail          P_tail

123               1.9                    0.9               1.88                    0.91

456               1.91               0,89               1.87                    1.02

 

 

please help,thx!

Outcomes