Transform and Transpose Table

[atair]

Hello. 

Can you help to dynamically transform and transpose a table :

ID	Product.No	Product.Value
123	10	300
123	20	100
123	30	200
222	30	123
222	20	432
222	10	151
111	20	878
111	10	656
111	30	545

Final result

Customer.ID	Product.No 10  (Vase)	Product.No 20  (Glass)	Product.No 30  (Pan)
111	656	878	545
123	300	100	200
222	151	432	123

Thanks

[Vegar]

Hi Atair
I would really recommend you to read @hic excellent Qlik Design Blog post about Generic Load in order to solve your issue.
https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470

/Vegar

[Vegar]

Hi, here is a second reply with a short advise. It is an good idea to rename the product no (in table 1) into the product description (in table 2) before applying the generic load.

I would recommend you to use Apply Map for this operation.

[jonathandienst]

When you say 'dynamically', do you mean doing the operation in the front end? If you plan to do the transform in the back end (load script), then generic load is the way to go.

This is simple enough to do in the front end. Create a pivot table with the customer and product dimensions, and drag the product dimension to the top of the table.

[anushree1 · Accepted solution]

please check the attached