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

    Like or Wildcard condition

    Rajesh NV

      Hi,

       

      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'

      End

       

      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!

       

      Regards,

      Rajesh

        • 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'

          end

           

           

          Jim

          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.