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

Anand2799
Tera Guru

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
Tera Patron

@v-paulp 

what's the context behind these tables?

this is related to core data setup?

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

Nilesh Pol
Kilo Sage
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...