Skip to Content
0
Former Member
Nov 23, 2016 at 09:24 AM

Convert data records from rows to columns?

117 Views Last edit Nov 23, 2016 at 08:34 PM 2 rev

Dear experts,

I want to transform data records from rows to columns.

E.g. of data record in my aDSO:

ID 1 | Data1 | Data2 | Data3

E.g. of required records in my new aDSO:

ID1 | Data1

ID1 | Data2

ID1 | Data3

Can anyone suggest a good way to do it or have a tutorial available? Is there a well known expression for this requirement? I was hardly able to find information about this problem...

Thank you and best regards!

Michael

/edit: found a working solution myself. this can be done by using rule groups.