The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

bshanesky's avatar
bshanesky
New Contributor II
2 years ago

Multiple sources for single target - conditional transformation

Hi All - explored other threads but could not find the right answer. Unsure if this should be one or two mappings and what type if they are a conditional rule or composite? If value at SourceAccoun...
Data Sources
Import
Transformation
bshanesky's avatar
bshanesky
New Contributor II
2 years ago

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

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 years ago

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