{"id":29249,"date":"2024-06-10T11:02:04","date_gmt":"2024-06-10T11:02:04","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=29249"},"modified":"2024-06-10T11:02:04","modified_gmt":"2024-06-10T11:02:04","slug":"how-to-add-a-field-in-data-model-designer-in-sei","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2024\/06\/10\/how-to-add-a-field-in-data-model-designer-in-sei\/","title":{"rendered":"How to add a field in data model designer in SEI"},"content":{"rendered":"\n<p>In this blog, we\u2019ll explore the step-by-step process of creating data models, linking tables, adding fields.<\/p>\n\n\n\n<p>Once the tables have been added and linked, fields can be added to the Data Model.<\/p>\n\n\n\n<p>Click on the &nbsp;to open the Fields.<\/p>\n\n\n\n<p>Right-click on the Field to access to these options:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Add Column,<\/li>\n\n\n\n<li>Join to Specific Values,<\/li>\n\n\n\n<li>Remove from Columns.<gwmw style=\"display:none;\"><\/gwmw><\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"345\" height=\"214\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig.-1.-Add-column.png\" alt=\"\" class=\"wp-image-29250\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig.-1.-Add-column.png 345w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig.-1.-Add-column-300x186.png 300w\" sizes=\"(max-width: 345px) 100vw, 345px\" \/><\/figure><\/div>\n\n\n<p class=\"has-text-align-center\"><strong>Fig. 1. Add column<\/strong><gwmw style=\"display:none;\"><\/gwmw><\/p>\n\n\n\n<p>Note:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Fields that have already been added and joined will be highlighted in blue.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Fields highlighted in blue with bold black font means they are added but not joined.<\/li>\n<\/ul>\n\n\n\n<p>Fields can be removed from the Data Model by right-clicking on the Field name and selecting Remove from Columns. It is possible to select multiple Fields by holding the Ctrl key and add them at the same time.<\/p>\n\n\n\n<p>Calculated fields can also be added to a Data Model by selecting Add Calculated Column from the Insert drop-down menu or by clicking on the \u00a0Add Calculated Column in the tool bar or by right-clicking in the Fields Table Section and selecting Add Calculated Column.<\/p>\n\n\n\n<p><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"494\" height=\"296\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig.-2.-Add-Calculated-Column.png\" alt=\"\" class=\"wp-image-29251\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig.-2.-Add-Calculated-Column.png 494w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig.-2.-Add-Calculated-Column-300x180.png 300w\" sizes=\"(max-width: 494px) 100vw, 494px\" \/><\/figure><\/div>\n\n\n<p class=\"has-text-align-center\"><strong>Fig. 2. Add Calculated Column<\/strong><\/p>\n\n\n\n<p class=\"has-text-align-left\">And also multiple fields were added by double-clicking on them.<gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"787\" height=\"372\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig.-3.-Add-multiple-fields.png\" alt=\"\" class=\"wp-image-29252\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig.-3.-Add-multiple-fields.png 787w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig.-3.-Add-multiple-fields-300x142.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig.-3.-Add-multiple-fields-768x363.png 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig.-3.-Add-multiple-fields-660x312.png 660w\" sizes=\"(max-width: 787px) 100vw, 787px\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-center\"><strong>Fig. 3. Add multiple fields<\/strong><\/p>\n\n\n\n<p>The Fields will always be added at the end of the list.<gwmw style=\"display:none;\"><\/gwmw><\/p>\n\n\n\n<p>You can easily re-order them by doing a drag and drop.<gwmw style=\"display:none;\"><\/gwmw><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"477\" height=\"380\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig.-4.-Re-order.png\" alt=\"\" class=\"wp-image-29253\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig.-4.-Re-order.png 477w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/06\/Fig.-4.-Re-order-300x239.png 300w\" sizes=\"(max-width: 477px) 100vw, 477px\" \/><\/figure><\/div>\n\n\n<p class=\"has-text-align-center\"><strong>Fig. 4. Re-order<\/strong><\/p>\n\n\n\n<p>The following three buttons &nbsp;in the toolbar can be used to resize the columns.<\/p>\n\n\n\n<p>Thus, we explored adding, removing, and creating calculated fields within the data model.<\/p>\n\n\n\n<p><gwmw style=\"display:none;\"><\/gwmw><\/p>\n\n\n\n<p><gwmw style=\"display:none;\"><\/gwmw><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog, we\u2019ll explore the step-by-step process of creating data models, linking tables, adding fields. Once the tables have been added and linked, fields can be added to the Data Model. Click on the &nbsp;to open the Fields. Right-click on the Field to access to these options: Fig. 1. Add column Note: Fields can\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2024\/06\/10\/how-to-add-a-field-in-data-model-designer-in-sei\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3,4,5,3162,13,7,8,3642,9,10,2796,11],"tags":[4208,4210,4209,3211,1943,3624,3735],"class_list":["post-29249","post","type-post","status-publish","format-standard","hentry","category-configuration","category-debug","category-faq","category-features","category-greytrix","category-integration","category-miscellaneous-tables","category-sage-erp-x3","category-sage-x3","category-sage-x3-consulting","category-standard","category-technical","category-tips","tag-add-fields-in-data-model","tag-data-model-in-sei","tag-fields-in-data-model-in-sei","tag-sage-x3-functional-blog","tag-sage-x3-technical-blog","tag-sei","tag-x3-blogs"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/29249","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=29249"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/29249\/revisions"}],"predecessor-version":[{"id":29255,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/29249\/revisions\/29255"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=29249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=29249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=29249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}