Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
userpd_2021
Contributor III
Contributor III

How to Transpose table on the script level?

Hi ,

How do we transpose the table on the script level?

Load dimension 1,dimension 2,dimension 3,Value,Week from Table1

Below is the table 

dimension 1 dimension 2 dimension 3 Value Week
123 abc 12ab PG W1
234 def 13ab XX W2
345 tre 14ab PG W1
456 euw 15ab PG W2
567 hdj 16ab PG W1
678 dsj 17ab PG W2
789 dhma 18ab XX W1
900 ksd 10ab PG W2
1011 hcd 10ab PG W1
1011 hcd 10ab PG W2

 

 

This is the required output

dimension 1 dimension 2 dimension 3 W1 W2
123 abc 12ab PG  
234 def 13ab   XX
345 tre 14ab PG  
456 euw 15ab   PG
567 hdj 16ab PG  
678 dsj 17ab   PG
789 dhma 18ab XX  
900 ksd 10ab   PG
1011 hcd 10ab PG PG
Labels (3)
2 Replies
MohammedMustaq
Partner - Creator
Partner - Creator

Something like these

if ("Week"='W1',Value) AS W1,
if ("Week"='W2',Value) AS W2