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

Question

Originally posted by Rich House4/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_*?

OSAdmin · Answer

Originally posted by Rich HouseI had a go and the answer is yes

Oscar · Answer

Hi ... Can you expand on how you achieved the mapping ... From the Source we have:50001_STAT,&nbsp;50002_STAT, ...,&nbsp;59999_STAT We want to do something like:SourceTarget5*_STAT5*_STAT&nbsp;

Forum Discussion

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

2 Replies

Related Content

QuickTips: Writing a Forms Event Handler Rule

Write Data to Dynamic Dimensions

Transformation Rule - Split - Complex Expression

Exclude members from rule expression

Rule Rules - ONLY write rules when necessary.

Source	Target
5*_STAT	5*_STAT