Skip to main content
Jun 18, 2020 2:04 PM UTC

Can I write a mask rule that says rule expression * and target value CC_*?

Originally posted by Rich House

4/22/2020

Hi, can I do this in transformation rules. I have cost centres 10001, 10002, etc. in the source in OS I have CC_10001, CC_10002 etc. Can I write a mask rule that says rule expression * and target value CC_*?

2 replies

Jun 26, 2020 3:22 PM UTC
Originally posted by Rich House

I had a go and the answer is yes

Contributor
Jul 27, 2022 2:13 PM UTC

Hi ... Can you expand on how you achieved the mapping ... From the Source we have:

50001_STAT, 50002_STAT, ..., 59999_STAT We want to do something like:

SourceTarget
5*_STAT5*_STAT