Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
atair
New Contributor

Transform and Transpose Table

Hello. 

Can you help to dynamically transform and transpose a table :

IDProduct.NoProduct.Value
12310300
12320100
12330200
22230123
22220432
22210151
11120878
11110656
11130545

 

Final result

Customer.IDProduct.No 10  (Vase)Product.No 20  (Glass)Product.No 30  (Pan)
111656878545
123300100200
222151432123

 

Thanks

Labels (1)
1 Solution

Accepted Solutions
anushree1
Valued Contributor II

Re: Transform and Transpose Table

please check the attached

View solution in original post

4 Replies
Partner
Partner

Re: Transform and Transpose Table

Hi Atair
I would really recommend you to read @Henric_Cronström 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
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Partner
Partner

Re: Transform and Transpose Table

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.
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Tags (2)
MVP
MVP

Re: Transform and Transpose Table

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
anushree1
Valued Contributor II

Re: Transform and Transpose Table

please check the attached

View solution in original post