Forum Discussion

Nicolas's avatar
Nicolas
Frequent Visitor
9 years ago
Solved

Using column header as values

Hello experts,   I have a tough one for you:   I have a bunch of columns like this:       Qry1  Qry2  Qry3  Qry4  Qry5  Qry6  Qry7  Qry8  Qry9  Qry10 1      N       N        N       N       N  ...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    Hi Nicolas,

     

    In the query editor do as follows:

    1 - Select all your columns

    2 - Unpivot columns

    3 - FIlter Y values

     

     

    Regards

     

    Mfelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

Hi Nicolas,

 

In the query editor do as follows:

1 - Select all your columns

2 - Unpivot columns

3 - FIlter Y values

 

 

Regards

 

Mfelix