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'm not sure if there is a way to do a -to-many style mapping. Everything we've done is a -to-one mapping. Hopefully someone else from the community can jump in and provide suggestions.
That said, typically there is some pattern that can be followed from the source system.
