Which stage(stages) to use

[forboy]

Hi,

Can any body help me here .

I have the data in the table like below.

Key1 Key2 code(Key3) status

A 1 X IN
A 1 Y IN
A 1 Z OUT
B 2 M IN
B 2 N IN
B 2 O OUT


How can I get the results like below.

col1 col2 col3(all codes seperated by comma) col4(codes where status = IN)

A 1 X,Y,Z X,Y
B 2 M,N,O M,N



what stage( or stages ) should I have to use to accomplish this

Thank You,
Nash

[narasimha]

Unfortunately there are no stages that can do this directly.
What you are planning is Vertical Pivoting.
You need to build one.
There are many examples discussed, do a search on Vertical Pivot.