I need to compare two email fields in a row and output if it is matching or not

[Padma_]

What tools/ regex can I use here, I have attached image for details.
I need to compare two email fields in a row and output if it is matching or not

[ChrisTX · Accepted solution]

Use a Formula tool to create a new field [Output that I need], data type V_String

IF [Email ID 1] = [Email ID 2] THEN "Matched" ELSE "Not Matched" ENDIF

To understand the Alteryx basics, at the top of this page try

  Learn > Academy > Learning Paths and Interactive Lessons

And review the Functions page:  Functions (alteryx.com)

Chris

[JosephSerpis · Accepted solution]

Hi @Padma_ from your example a formula tool with a If formula should give you the desired results.

If [Email ID 1] = [Email ID 2] Then "Matched" Else "Not Matched" Endif

[Padma_]

Hi All,

I tried the same, it was erroring hence I posted here, I just realized, I made mistake with the data upstream.

I fixed it it is working.

Thanks All.