DSXchange

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

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.