How to compare and detect change between a non-spatial table with a feature attribute table?

Perhaps the FeatureJoiner? Perhaps I'm not understanding, however a FeatureJoiner can be used with multiple columns (and you don't need to rename them). One that don't match will come out of either the unjoined left or unjoined right ports

Have you looked at the ChangeDetector?

@smfks911​ can you show is or attach an example of the data and what result you'd like to see. That might help clarify your question

Hi @geomancer​ I have tried already but it is not giving me the output I require.

Hi @virtualcitymatt​ I have tried featureJoiner but the unjoined left includes many including two rows that I want to be picked actually.

Hi @Mark Stoakes​, Table 1 (which need to compare against table 2): here I have changed attribute values of two rows

Table 2 comes from a featureclass where these two particular rows does not exist

so my interest is to check the first table against the table 2 and return me the rows/entries that have wrong (or mismatch) attribute value for that particular attribute.

Strange, it is a logical choice when you want to detect missing or extra ID's and changes in attributes.

After working with the source tables, I have figured out the problem is in the data itself. So both changedetector and featuremerger would have worked well if the source datasets were ok. For timebeing, we need to work to fix the data first. Thank you so much.

Ahhh the ol' data issue - a classic headache. Good your were able to eventually track it down. Good luck with the project

Thanks for your feedback, @smfks911​ . I hope you get your data sorted out. Good luck!