Skip to Content
0
May 06, 2008 at 06:34 PM

Unique Trans Problem

30 Views

I have a datastore that needs to be transformed from a row format to a column format or rather a standard db format.

So my source looks like:

DSA

id fld text

1 a txt1a

1 b txt1b

1 c txt1c

2 a txt2a

2 b txt2b

2 c txt2c

I'd like it in this format:

DSB

id a b c

1 txt1a txt1b txt1c

2 txt2a txt2b txt2c

In DSB id is the key field so it will only be there once.

So i have a transformation from DSA -> DSB and now I think I need just to map the DSA.id to DSB.id and some ABAP to read the rest.

Anyone have some sample code on how I can do this?

Points rewards !!!