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.
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).
