{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":9480,"path":"employee-service-management/contract-management-pro/cncore-append-data-table.md","title":"Configure mapped columns to append or add fields from related tables","bundle":null,"doc_type":null,"release":"australia","body":"\n# Configure mapped columns to append or add fields from related tables\n\nConfigure dynamic tables in a contract template to display additional data from related table fields by appending it to existing columns or adding it as new columns.\n\n## About this task\n\nAs a contract configurator, you can add scripts for configuring the mapped table columns in a contract template to include additional fields from related tables. You can choose to either append this information to an existing column or add it as a new column.\n\n## Before you begin\n\n-   Map tables in Microsoft Word document using the Microsoft Word add-in for ServiceNow Contracts. For more information, see [Map contract tables using the Microsoft Word add-in for ServiceNow Contracts](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/employee-service-management/contract-management-pro/cncore-addin-table.md).\n-   Upload and parse the document with the content controls. For more information, see [Complete mapping and upload Microsoft Word document that includes content controls](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/employee-service-management/contract-management-pro/cncore-upload-doc-addin.md).\n-   Role required: sn\\_cm\\_core.contract\\_config\n\n## Procedure\n\n1.  Navigate to **All** > **Contracts Core** > **Contract Administration** > **Contract Templates**.\n\n2.  From the list, open the contract template for which you want to add table mapping conditions.\n\n3.  In the Table Mappings related list, select a mapping.\n\n4.  In the Column Mapping related list, select a column.\n\n5.  In the Column Mapping form, select the **Advanced script** check box.\n\n    The **Script** field appears.\n\n    \\[Omitted image \"cmpro-script-table.png\"\\] Alt text: Advanced script on the column mapping form to configure additional fields for mapped table\n\n6.  In the **Script field**, add the script to include additional fields from related tables.\n\n7.  Select **Update**.\n\n8.  In the Table Mapping form, select **Update**.\n\n\n## Result\n\nThe additional fields will be appended to a column or added as a new column in the contract document that is generated using this template.\n\n**Parent Topic:**[Map contract tables using the Microsoft Word add-in for ServiceNow Contracts](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/employee-service-management/contract-management-pro/cncore-addin-table.md)\n\n"}}