Best practice for mapping between multiple tables in servicenow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
Hi All,
We have 3 tables for Region , country and Portfolio . And we need to mapped country and portfolio with region.
For that what is the best practice in ServiceNow?
Thanks
Pradip Paul
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
Hi @v-paulp ,
The approach depends on how your data is organized and the relationships between the tables.
If you need a parent-child relationship between Region and Country, or Region and Portfolio, add a field in the Country and Portfolio tables that references the Region table.
Thanks
Anand
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
what's the context behind these tables?
this is related to core data setup?
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
@v-paulp You can use Decision Table - If the mapping involves complex logic or conditional rules (e.g., based on multiple criteria or business rules), decision tables can be a powerful tool. They allow you to encapsulate complex decision-making logic in a structured format and automate the mapping process based on predefined rules.
refer the link: https://www.servicenow.com/docs/bundle/zurich-application-development/page/administer/decision-table...