Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to switch this table's rows to columns?
So that it looks like as below
Mon | Tue | Wed | Thu | Fri | Sat | Sun |
A | A, C | A, A, C | B | B | B | A, 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]
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