Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
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