1 Reply Latest reply on Sep 23, 2018 4:20 AM by Jim Dehner

    Like or Wildcard condition

    Rajesh NV



      I have one of the formula in tableau:


      IF Result = 'Source' or Result ='Sourcedata' or Result = 'SourceRef'  then 'SourceFound'

      ELSEIF Result = 'Destination' or Result ='Destdata' or Result = 'DestRef'  then 'DestFound'



      Instead above in tableau formula in Like or wildcard condition. Example. If Result is "source%" then "SourceFound". If result is "Dest%" then "Destfound". Can anyone help!




        • 1. Re: Like or Wildcard condition
          Jim Dehner

          Good morning

          try using Contains



          as in   if contains([result],'source') then 'Source Found'

          elseif contains([result],'dest') then 'destination Found'





          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.