Forum Discussion
Anonymous
4 years agoNot applicable
undefined
I have a three column i want a result like it select" T " from col1- and that should not contain 0 and null from col2 and col3 col1 col2 col3 A 1 null A 2 ...
Ashish_Mathur
Super User
4 years agoHi,
In the Query Editor, right click on the first column's heading and select "Unpivot Other Columns". Filter the Value column with the criteria >0. Does this help?