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!
/edit: found a working solution myself. this can be done by using rule groups.