Retrieve "Unmatched" data from two excel data sets

[SubbuSharma]

Hello,

I am connecting the two excel data sets and trying to retrieve the "Unmatched" data. For instance, I am matching Assignment ID from file 1 to Assignment ID to file 2; once done, I would like to retrieve those ID which are "NOT MATCHED" in both the files. Could you please let me know a solution for this, please.

Thanks

Subbu

[BrandonB · Accepted solution]

If you use a join tool where you connect both datasets and configure it to join on Assignment ID to Assignment ID, you should see the unmatched results coming out of the L or the R anchors on the right hand side of the join tool. This would respectively represent the unmatched records from both data sets.

[SubbuSharma]

thank you, that was helpful. It worked and I am able to distinguish the data the way I would like.