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 !!!