Switch table column

[Keyuser]

Hello!

Following table:

order number	sub	weight
1234567		50
1234567	1	70
1234567	2	90
9876543		30
9876543	1	50
9876543	2	60

Now would like to represent the weight of oder numer  & sub  in one line.

ornder number	weight order number	weight sub 1	weight sub 2
1234567	50	70	90
9876543	30	50	60

Thank you for your help!

[PrashantSangle]

Use generic Load
try below script

Temp:
Load * Inline [
order_number, sub, weight
1234567, 0 , 50
1234567, 1, 70
1234567, 2, 90
9876543, 0, 30
9876543, 1, 50
9876543, 2, 60
];


test2:
Generic Load * Resident Temp;

drop Table Temp;

Regards,
Prashant Sangle