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!
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.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...