OK then I guess I need to ask the question the other way. How can I indicate the target account starts with 7 or can I not do this? When I gave the example of A#[7*]: the 7 was the OS target account not the source account.
The OS 7x accounts should be the only one with departments but the source account numbers are not consistent. So I am trying to figure out how to make all records that have a target account <> 7* to equal 'None' and then all records that have a target account that is 7* to do the 1:1 mapping.
I suggest for the Account <> 7* use the Mask type * to * and then use a conditional BR something like below for the UD3 transformation.
Dim account As String = args.GetTarget("A#")
Dim u3 As String = args.GetSource("U3#")
If Not account.StartsWith("7")
Return "None"
Else
Return u3
End If