Best practice for mapping between multiple tables in servicenow

[Community Alums]

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

[Anand__99]

Hi @Community Alums ,

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]

@Community Alums 

what's the context behind these tables?

this is related to core data setup?

[Nilesh Pol]

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