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).
My understanding is that you essentially want to use a different set of transformation rules based on the value of one data point that exists in the imported data set. If that's the case, you'll have an issue because if the value is null, that line will be skipped. If the value is 0, that line will also be skipped if your zero suppression setting on your data source is set to True.
If you're able, I suggest using a different method for determining which set of transformation rules the imported data should use.
