Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
nezuko_kamado
Creator
Creator

How to switch column and row position?

How to switch this table's rows to columns?

table.PNG

 

 

 

 

 

 

So that it looks like as below

MonTueWedThuFriSatSun
AA, CA, A, CBBBA, A, B, B, C

 

data:
load*inline [calendar, Product, Weekday
10/1/2021, A, Fri
10/1/2021, B, Fri
10/1/2021, A, Fri
10/2/2021, C, Sat
10/2/2021, C, Sat
10/2/2021, A, Sat
10/2/2021, B, Sat
10/3/2021, A, Sun
10/3/2021, A, Sun
10/3/2021, C, Sun
10/3/2021, B, Sun
10/3/2021, B, Sun
10/4/2021, A, Mon
10/5/2021, C, Tue
10/5/2021, A, Tue
10/6/2021, A, Wed
10/6/2021, C, Wed
10/6/2021, A, Wed
10/7/2021, B, Thu
10/8/2021, B, Fri
10/9/2021, B, Sat
10/10/2021, A, Sun
10/10/2021, C, Sun
10/10/2021, A, Sun]

Labels (1)
1 Reply
Vegar
MVP
MVP

You can solve this using GENERIC load. Take a look at this old community posting: https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470