Skip to main content
June 18, 2020

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

  • June 18, 2020
  • 2 replies
  • 0 views
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

June 26, 2020
Originally posted by Rich House

I had a go and the answer is yes

Contributor
July 27, 2022

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