Skip to Content
0

Convert data records from rows to columns?

Nov 23, 2016 at 09:24 AM

69

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers