Skip to main content
Newcomer
July 27, 2022
Solved

Transformation Rule mapping based on a target of another dimension

  • July 27, 2022
  • 2 replies
  • 0 views

Hi All,

Can we build a transformation rule with a logic that if the target of lets say UD4 is 'xxxx' and source Account number is 'yyyy' then UD3 gets mapped to a particular code?
To simplify- Need to look at Target for UD4 and Source for Account to map to a specific UD3.

Thanks.

Best answer by DanielWillis

Are you still trying to figure this out? You can create a complex expression on a mask rule and utilise args.GetSource & args.GetTarget, e.g. below syntax return the values you asked about.

args.GetSource("A#")
args.GetTarget("UD4#")

2 replies

Contributor
July 27, 2022

Hi Mayank: I think a Conditional BR will be required, check out the solution proposed by Sal in this post. https://community.onestreamsoftware.com/t5/Workflow-and-Data-Integration/Composite-Rule-before-1-1-Rule-Order-not-Working/td-p/8719#.YuGPzpNmb64.link

-db

Contributor
August 1, 2022

Are you still trying to figure this out? You can create a complex expression on a mask rule and utilise args.GetSource & args.GetTarget, e.g. below syntax return the values you asked about.

args.GetSource("A#")
args.GetTarget("UD4#")