Forum Discussion

Nirod95's avatar
Nirod95
New Contributor
9 days ago

Understanding TR

Im having an issue with a transformation rule where i have on stage : - Account 5115-0001 -UD2 2350 -UD4 2020 That combination of dimensions is being assigned by the following TR A#[5015~51...
Application Properties
MarcusH's avatar
MarcusH
Contributor III
9 days ago

The range map cannot be split like that. I suspect it is using 5015 as the start and 5115-0406 as the end. In which case 5115-0001 falls within the range. Range maps are tricky and can give unexpected results. Consider 3 range maps like this :

 

A#[5015-0406~5115-0406]:UD4#[2012~2080]:UD2#[2206~2999]
A#[5015-0407~5115-0407]:UD4#[2012~2080]:UD2#[2206~2999]
A#[5015-0408~5115-0408]:UD4#[2012~2080]:UD2#[2206~2999]

 

This will also map any source accounts beginning with 5016-xxxx, 5017-xxxx and so on. You are wanting to match two aspects of the source: 5015 to 5115 and 0406 to 0408. You will have to add a Complex expression or Business Rule. If you create a map like this: 

 

A#[5015-0406~5115-0408]:UD4#[2012~2080]:UD2#[2206~2999]

 

and then use the Complex Expression or Business Rule to check that the last four characters are 0406 or 0407 or 0408.

 

Related Content