Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- OneStream Community
- Forums
- Workflow and Data Integration
- Can I write a mask rule that says rule expression * and target value CC_*?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Can I write a mask rule that says rule expression * and target value CC_*?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-18-2020 10:04 AM
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_*?
Labels:
- Labels:
-
Data Sources
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-26-2020 11:22 AM
Originally posted by Rich House
I had a go and the answer is yes
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-27-2022 10:13 AM
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:
| Source | Target |
| 5*_STAT | 5*_STAT |
Please sign in!
OSAdmin
Related Content
- obsolete functions in Rules
- How can I ( if possible ) set a UD static value from a data source based on contents of a column in Workflow and Data Integration
- Range Transformation Rule not working in Workflow and Data Integration
- vStageSourceAndTargetData Converted Amount in Reporting
- Multiple Or Statements in Reporting
Community Resources
Training and Documentation
Additional Resources
