The input table has data spread across multiple records in the following format
ItemID,AttributeID,AttributeValue
There are multiple attributes allocated to each Item, each attribute having a value.
I'm trying to "pivot" the data to end up with a table of the following format
Code: Select all
ItemID | Attribute1 | Attribute2 | ...
-------------------------------------------------
Item1 | Attribute1Value | Attribute2Value | ...
Item2 | Attribute1Value | Attribute2Value | ...
.
.
.
Running on DS 11.5.0.1
Any help much appreciated...