Dimension Look-up during Transformation
We are trying to develop logic to do the following during transformation:
If the G/L account in the load is in a certain range and the UD2 member is valid, load to that intersection
otherwis...
Forum Discussion
Give this a try with Conditional BR
1. Create a conditional business rule and do something like this
Dim account As Integer = args.GetSource("Ac#").XFConvertToInt
Dim ud2 As String = args.GetSource("U2#")
If account >= 1000 And account <= 2000 Then
If ud2 = "valid" Then 'check for valid U2#
Return ud2
Else
Return "None"
End If
Else
Return ud2
End If
2. Attach this BR to your UD2 Transformation