Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to transform below data to as shown in the output. Note that there are tens of Products and hundreds of Groups. Each Product-Group is a unique combination i.e. A-1 can only appear once in the raw data in qvd
Input data (in qvd)
Product | Group | Amount
A | 1 | 100
A | 2 | 200
B | 1 | 150
B | 2 | 250
Required Output
Group | A | B
1 | 100 | 150
2 | 200 | 250
Try using Generic load, like:
Generic Load Group, Product, Amount
From <qvd> ;