Compare row to rows in different sheet

[Savannah]

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! 🙂

[PhilipMannering · Accepted solution]

Hi @Savannah,

A couple of options in the attached file. 

[Qiu · Accepted solution]

@Savannah 

Here is another one for you.

[Savannah]

Many thanks for your reply! Let me give this a try and come back. 

[Savannah]

Many thanks for this! I will have a go at it and post back. 

[Savannah]

OMG, you saved me a couple of weeks of work! Fantastic! So many thanks! 

[Savannah · Accepted solution]

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