topic Re: Transform and Transpose Table in QlikView

Transform and Transpose Table

atair — Sat, 16 Nov 2024 21:10:52 GMT

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

Re: Transform and Transpose Table

Vegar — Tue, 26 Mar 2019 04:50:57 GMT

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

Re: Transform and Transpose Table

Vegar — Tue, 26 Mar 2019 04:57:23 GMT

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.

Re: Transform and Transpose Table

jonathandienst — Tue, 26 Mar 2019 07:05:38 GMT

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.

Re: Transform and Transpose Table

anushree1 — Tue, 26 Mar 2019 07:27:16 GMT

please check the attached