Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Best practice for mapping between multiple tables in servicenow

v-paulp
Tera Contributor

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

3 REPLIES 3

Anand__99
Kilo Sage

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

Ankur Bawiskar
Tera Patron

@v-paulp 

what's the context behind these tables?

this is related to core data setup?

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

Nilesh Pol
Kilo Sage

@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...