Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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         0
T        3          0
T       0          null
T       null      6

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    Anonymous Maybe:

    col4 = 
  SWITCH(TRUE(),
    [col1] = "T" && [col2] > 0 && [col3] > 0, TRUE(),
    FALSE()
  )
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    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? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    what's your meaning of "not contain 0 and null from col2 and col3",from your description, I know you want to filter col1，but I don't understand "not contain o and null", because unless you delete col2 and col3, if you filter on this table, it will show the whole row.

     

    So can you give me your expected result? so that i can know what you want.

     

    Best regards,

    Community Support Team Selina zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.