Calculated Column if 2 Fields Match

jhartley
jhartley ⚪️
in Beastmode & Analytics

Hi - I am trying to create a calculated field similar to the = or EXACT function in excel - example =IF(TRIM(A27)=TRIM(B27),"Match","No Match")

I need to know if 2 columns have fields that match for any value. Specifically, if email addresses are the same in each column. Thanks!

Tagged:

Answers

  • RobSomers
    RobSomers 🟢

    @jhartley

    case when 'Field1' = 'Field2' then 'Match' else 'No Match' end

    **Was this post helpful? Click Agree or Like below**

    **Did this solve your problem? Accept it as a solution!**

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🥷

    Use the CASE statement to do this:

    CASE WHEN TRIM(LOWER(`email1`)) = TRIM(LOWER(`email2`)) THEN 'Match' ELSE 'No Match' END


    Using TRIM and LOWER will also help to ensure that it evaluates properly.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories