QlikSense Data Modelling Transpose or Pivot in script

[cprasad111]

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

[tresesco]

Try using Generic load, like:

Generic Load 
	Group, Product, Amount
From <qvd> ;