I have 2 datasets - dataset A and B, as shown below. When I merge by ID, I get the resulting dataset, also shown below. What I would like to have, is for record 1 in dataset A to merge with record_ 3 in dataset B, and record 2 with record_ 4, so that record 1 doesn't go ahead and merge with record_ 4, and record_ 3 is not available for merging with record 2. This is shown below in "Desired Merged Dataset". Thanks in advance! Dataset A Record ID Qty 1 ABC 30 2 ABC 30 Dataset B Record_ ID Qty_ 3 ABC -30 4 ABC -30 Resulting Merged Dataset ID Record Record_ Qty Qty_ ABC 1 3 30 -30 ABC 1 4 30 -30 ABC 2 3 30 -30 ABC 2 4 30 -30 Desired Merged Dataset ID Record Record_ Qty Qty_ ABC 1 3 30 -30 ABC 2 4 30 -30
... View more