Thanks chul
I'm realizing it may be more complicated than initially described since there are multiple other dimensions that need to match.
With some more context:
SourceAccountMAIN is a binary. So where all other dimensions match, if the binary value there is 1, there should be two distinct one to one mappings (A to B, C to D).
And in all other cases of the binary (0 or null), where other dimensions match, there are another two distinct one to one mappings (E to B, F to D).
It's not clear to me whether "SourceAccountMAIN" is a field that appears on each record or not. That makes all the difference.
I think it would be a bit clearer if you could actually post the structure of each record (i.e. row headers).
