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_*?

Related Content

SetDataCellsUsingMemberScript writes only the last record

Rule Rules - ONLY write rules when necessary.

Rule to write to Cell Details?

Data sources zero suppression with complex expression

Exclude members from rule expression

Source	Target
5*_STAT	5*_STAT