{"id":32248,"date":"2021-01-15T12:19:23","date_gmt":"2021-01-15T12:19:23","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=32248"},"modified":"2021-01-15T12:21:25","modified_gmt":"2021-01-15T12:21:25","slug":"about-column-properties","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/about-column-properties\/","title":{"rendered":"About Column Properties"},"content":{"rendered":"\n<p><strong>Configure column Properties Settings<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, in the model designer, in a table, select a column.<\/li><li>Then, in the&nbsp;Column <strong>Properties<\/strong>&nbsp;window, click on a property, and then type a value or click the down arrow to select a setting option.<\/li><\/ul>\n\n\n\n<p><strong>Advanced<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Property<\/th><th>Default Setting<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td><strong>Display Folder<\/strong><\/td><td><\/td><td>It is a single or nested folder for organizing columns in a client application field list.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Basic<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Property<\/th><th>Default Setting<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td><strong>Column Name<\/strong><\/td><td><\/td><td>The name of the column as it is stored in the model and as it is displayed in a reporting client field list.<\/td><\/tr><tr><td><strong>Data Format<\/strong><\/td><td>Automatically determined during import.<\/td><td>It specifies the display format to use for the data in this column. This property has the options &#8211; General, <br>Decimal Number, Whole Number, Currency, Percentage and Scientific. Once you set a data format, you can set column properties that are specific to each format. <br>In case, the column values contain images, see&nbsp;<strong>Representative Image<\/strong>.<\/td><\/tr><tr><td><strong>Data Type<\/strong><\/td><td>Automatically determined during import.<\/td><td>It is used to specify the data type for all values in the column.<\/td><\/tr><tr><td><strong>Description<\/strong><\/td><td><\/td><td>It is a text description for the column. In certain reporting clients, if an end-user places the cursor over this column in the field list, the description appears as a tooltip.<\/td><\/tr><tr><td><strong>Hidden<\/strong><\/td><td>False<\/td><td>It is used to specify whether the column is hidden from reporting client field lists. Then, set this property to&nbsp;<strong>True<\/strong>&nbsp;to hide this column in the display. <br><br>Now, if you hide a column from the reporting client, the field is not suppressed in the model data. The field is still visible if you create a query against the model. Therefore, a hidden column can still be used for grouping or sorting.<br><br>The&nbsp;<strong>Hidden<\/strong>&nbsp;property does not provide any form of data security. To secure data, use row filters in Roles. <\/td><\/tr><tr><td><strong>Sort By Column<\/strong><\/td><td><\/td><td>It is used to specify another column to sort the values in this column. Moreover, a relationship must exist between the two columns. Also, this value must be the name of an existing column. Note &#8211; We cannot specify a formula or measure.<\/td><\/tr><tr><td><strong>Unique<\/strong><\/td><td><\/td><td>It is used to set to enforce uniqueness of values in the column. Always true for calculated columns, even if uniqueness is false.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Misc.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Property<\/th><th>Default Setting<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td><strong>Encoding Hints<\/strong><\/td><td>Default<\/td><td>It is used to specify the encoding to optimize processing. Further, value encoding can improve query performance for numeric columns typically used in aggregations. <br>Hash encoding is for group-by columns (often dimension-table values) and foreign keys. String columns are always hash encoded.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Reporting Properties<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Property<\/th><th>Default Setting<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td>Default Image<\/td><td>False<\/td><td>It is used to specify the column that provides an image that represents the row data (Example &#8211; a photo ID in an employee record).<\/td><\/tr><tr><td>Default Label<\/td><td>False<\/td><td>It is used to specify which column provides a display name to represent row data (For instance, employee name in an employee record).<\/td><\/tr><tr><td>Image URL\/Data Category (SP1)<\/td><td>False<\/td><td>It is used to specify the value in this column as a hyperlink to an image on a server. <\/td><\/tr><tr><td>Keep Unique Rows<\/td><td>False<\/td><td>It is used to specify which columns provide values that should be treated as unique even if they are duplicates <\/td><\/tr><tr><td>Row Identifier<\/td><td>False<\/td><td>It is used to specify a column that contains only unique values, allowing that column to be used as an internal grouping key.<\/td><\/tr><tr><td>Summarize By<\/td><td>Default<\/td><td>This property applies only to columns of the type that can be aggregated. It is used to specify reporting client tools for applying the aggregate function SUM for column calculations when this column is added to a Field list. To change the default calculation, select it from the dropdown list. <\/td><\/tr><tr><td>Table Detail Position<\/td><td>No Default Field Set<\/td><td>It is used to specifies this column or measure can be added to a set of fields from a single table to enhance the table visualization experience in a reporting client.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/analyzing-data-with-microsoft-power-bi-da-100-free-test\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"961\" height=\"150\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png\" alt=\"Microsoft Exam DA-100 Free Practice Test\" class=\"wp-image-31483\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png 961w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test-750x117.png 750w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Configure column Properties Settings Firstly, in the model designer, in a table, select a column. Then, in the&nbsp;Column Properties&nbsp;window, click on a property, and then type a value or click the down arrow to select a setting option. Advanced Property Default Setting Description Display Folder It is a single or nested folder for organizing columns&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[174],"tags":[4022,1830,3954],"class_list":["post-32248","page","type-page","status-publish","hentry","category-microsoft-azure","tag-column-properties","tag-da-100-study-guide","tag-microsoft-exam-da-100-free-practice-test"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>About Column Properties - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Boost your chances to qualify Micrososft Exam DA-100 with latest and updated practice test. Learn more about column properties Now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/about-column-properties\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"About Column Properties - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Boost your chances to qualify Micrososft Exam DA-100 with latest and updated practice test. Learn more about column properties Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/about-column-properties\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-15T12:21:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/about-column-properties\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/about-column-properties\/\",\"name\":\"About Column Properties - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2021-01-15T12:19:23+00:00\",\"dateModified\":\"2021-01-15T12:21:25+00:00\",\"description\":\"Boost your chances to qualify Micrososft Exam DA-100 with latest and updated practice test. Learn more about column properties Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/about-column-properties\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/about-column-properties\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/about-column-properties\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"About Column Properties\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"About Column Properties - Testprep Training Tutorials","description":"Boost your chances to qualify Micrososft Exam DA-100 with latest and updated practice test. Learn more about column properties Now!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.testpreptraining.ai\/tutorial\/about-column-properties\/","og_locale":"en_US","og_type":"article","og_title":"About Column Properties - Testprep Training Tutorials","og_description":"Boost your chances to qualify Micrososft Exam DA-100 with latest and updated practice test. Learn more about column properties Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/about-column-properties\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2021-01-15T12:21:25+00:00","og_image":[{"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/about-column-properties\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/about-column-properties\/","name":"About Column Properties - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2021-01-15T12:19:23+00:00","dateModified":"2021-01-15T12:21:25+00:00","description":"Boost your chances to qualify Micrososft Exam DA-100 with latest and updated practice test. Learn more about column properties Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/about-column-properties\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/about-column-properties\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/about-column-properties\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"About Column Properties"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/32248","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=32248"}],"version-history":[{"count":3,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/32248\/revisions"}],"predecessor-version":[{"id":32271,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/32248\/revisions\/32271"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=32248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=32248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=32248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}