Compare row to rows in different sheet

Question

Hello Community!

I have a lookup value in Sheet1, Account #, which I then want to lookup in Sheet2.

When Alteryx finds it, I want to compare the rows in Sheet1 and Sheet2.

If any value in the rows doesn't match, I'd like it flagged.

I have attached a sample.

Any suggestions and ideas would be much appreciated! 🙂

File1.xlsx

philipmannering · Accepted Answer

Hi @Savannah,

A couple of options in the attached file.

Qiu · Accepted Answer

@Savannah

Here is another one for you.

Savannah · Accepted Answer

This worked fantastically well too! Thank you so much for saving me a lot of time!