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
Solved! Go to 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.
thank you, that was helpful. It worked and I am able to distinguish the data the way I would like.