{"id":3893,"date":"2015-02-02T13:44:02","date_gmt":"2015-02-02T13:44:02","guid":{"rendered":"http:\/\/www.qgate.co.uk\/knowledge\/?p=3893"},"modified":"2025-06-04T10:23:34","modified_gmt":"2025-06-04T10:23:34","slug":"managing-information-columns-converting-picklist-codes","status":"publish","type":"post","link":"https:\/\/www.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/","title":{"rendered":"Managing the Information Columns &#8211; Converting Picklist Codes"},"content":{"rendered":"<p><!----------------------------- Article Header Start - DO NOT REMOVE ------------------------------><\/p>\n<table class=\"article-header-table\" summary=\"Article Summary\">\n<tbody>\n<tr class=\"qgkb-articleheader-table-header\">\n<td style=\"border-top: 5px solid currentColor;\" valign=\"top\" width=\"25%\"><b>Summary:<\/b><\/td>\n<td style=\"border-top: 1px solid currentColor;\" valign=\"top\">Some systems hold the codes of picklist fields and not the text value displayed in the CRM table\/entity being cleansed.<\/td>\n<\/tr>\n<tr class=\"qgkb-articleheader-table-summary\">\n<td valign=\"top\"><b>Article Type:<\/b><\/td>\n<td valign=\"top\">How-To Guide<\/td>\n<\/tr>\n<tr class=\"qgkb-articleheader-table-summary\">\n<td style=\"border-bottom-color: currentColor; border-bottom-width: 3px; border-bottom-style: solid;\" valign=\"top\"><strong>Related Product(s):<\/strong><\/td>\n<td style=\"border-bottom-color: currentColor; border-bottom-width: 1px; border-bottom-style: solid;\" valign=\"top\">This article relates to the following products:<\/p>\n<ul>\n<li>Paribus 365&#x2122; Data Cleansing<\/li>\n<li>Microsoft Dynamics 365 CRM<\/li>\n<li>Infor CRM SLX (Saleslogix)<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><!-------------------------------------- Article Header End ---------------------------------------><br \/>\n<!-- Article Content --><\/p>\n<h2>Introduction<\/h2>\n<p>For the reviewers of Paribus 365&#x2122; Data Cleansing Match Results having information columns that speed up the decision are important. The information columns displayed are controlled in the Data Set.<\/p>\n<figure id=\"attachment_3894\" aria-describedby=\"caption-attachment-3894\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.qgate.co.uk\/knowledge\/wp-content\/uploads\/2015\/02\/fig1-picklist.png\"><img loading=\"lazy\" class=\"wp-image-3894 size-medium\" src=\"https:\/\/www.qgate.co.uk\/knowledge\/wp-content\/uploads\/2015\/02\/fig1-picklist-300x198.png\" alt=\"Data Set Definition\" width=\"300\" height=\"198\" srcset=\"https:\/\/www.paribuscloud.com\/help\/wp-content\/uploads\/2015\/02\/fig1-picklist-300x198.png 300w, https:\/\/www.paribuscloud.com\/help\/wp-content\/uploads\/2015\/02\/fig1-picklist-1024x675.png 1024w, https:\/\/www.paribuscloud.com\/help\/wp-content\/uploads\/2015\/02\/fig1-picklist-624x411.png 624w, https:\/\/www.paribuscloud.com\/help\/wp-content\/uploads\/2015\/02\/fig1-picklist.png 1218w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-3894\" class=\"wp-caption-text\">Fig 1<\/figcaption><\/figure>\n<p>As well as adding standard fields the information displayed can be enhanced further.<\/p>\n<h2>Converting Picklist Values<\/h2>\n<p>Some systems hold the codes of picklist fields and not the text value displayed in the CRM table\/entity being cleansed.&nbsp; This means that sometimes the code will be displayed when selecting a picklist field.<\/p>\n<figure id=\"attachment_4271\" aria-describedby=\"caption-attachment-4271\" style=\"width: 342px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.qgate.co.uk\/knowledge\/wp-content\/uploads\/2015\/02\/dr-kb-2.png\"><img loading=\"lazy\" class=\"size-full wp-image-4271\" src=\"https:\/\/www.qgate.co.uk\/knowledge\/wp-content\/uploads\/2015\/02\/dr-kb-2.png\" alt=\"Figure 2\" width=\"342\" height=\"289\" srcset=\"https:\/\/www.paribuscloud.com\/help\/wp-content\/uploads\/2015\/02\/dr-kb-2.png 342w, https:\/\/www.paribuscloud.com\/help\/wp-content\/uploads\/2015\/02\/dr-kb-2-300x253.png 300w\" sizes=\"(max-width: 342px) 100vw, 342px\" \/><\/a><figcaption id=\"caption-attachment-4271\" class=\"wp-caption-text\">Fig. 2<\/figcaption><\/figure>\n<p>The reviewer will wish to see the text value.&nbsp; Where it is not available directly, a SQL Case statement can be used within the Information Column selection to convert the codes to text values as shown in example below.<\/p>\n<p>CASE contact.gendercode<\/p>\n<p>WHEN&nbsp; 1 THEN &#8216;Male&#8217;<\/p>\n<p>WHEN&nbsp; 2 THEN &#8216;Female&#8217;<\/p>\n<p>END as Gender<\/p>\n<p>For example, it would be added as follows:<\/p>\n<figure id=\"attachment_4272\" aria-describedby=\"caption-attachment-4272\" style=\"width: 468px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.qgate.co.uk\/knowledge\/wp-content\/uploads\/2015\/02\/dr-kb-3.jpg\"><img loading=\"lazy\" class=\"size-full wp-image-4272\" src=\"https:\/\/www.qgate.co.uk\/knowledge\/wp-content\/uploads\/2015\/02\/dr-kb-3.jpg\" alt=\"End as Gender\" width=\"468\" height=\"510\" srcset=\"https:\/\/www.paribuscloud.com\/help\/wp-content\/uploads\/2015\/02\/dr-kb-3.jpg 468w, https:\/\/www.paribuscloud.com\/help\/wp-content\/uploads\/2015\/02\/dr-kb-3-275x300.jpg 275w\" sizes=\"(max-width: 468px) 100vw, 468px\" \/><\/a><figcaption id=\"caption-attachment-4272\" class=\"wp-caption-text\">Fig. 3<\/figcaption><\/figure>\n<p>This change will result in a more informative value being displayed in the review:<\/p>\n<figure id=\"attachment_4273\" aria-describedby=\"caption-attachment-4273\" style=\"width: 334px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.qgate.co.uk\/knowledge\/wp-content\/uploads\/2015\/02\/dr-kb-4.png\"><img loading=\"lazy\" class=\"wp-image-4273 size-full\" src=\"https:\/\/www.qgate.co.uk\/knowledge\/wp-content\/uploads\/2015\/02\/dr-kb-4.png\" alt=\"Gender Female\" width=\"334\" height=\"282\" srcset=\"https:\/\/www.paribuscloud.com\/help\/wp-content\/uploads\/2015\/02\/dr-kb-4.png 334w, https:\/\/www.paribuscloud.com\/help\/wp-content\/uploads\/2015\/02\/dr-kb-4-300x253.png 300w\" sizes=\"(max-width: 334px) 100vw, 334px\" \/><\/a><figcaption id=\"caption-attachment-4273\" class=\"wp-caption-text\">Fig. 4<\/figcaption><\/figure>\n<p><!----------------------------- Article Footer Start - DO NOT REMOVE ------------------------------><\/p>\n<table style=\"border-bottom: none;\" summary=\"Article Summary\">\n<tbody>\n<tr class=\"qgkb-articleheader-table-summary\">\n<td style=\"width: 25%; border-top-color: currentColor; border-top-width: 3px; border-top-style: solid;\" valign=\"top\"><strong>&nbsp;Related Resources:<\/strong><\/td>\n<td style=\"width: 75%; border-top-color: currentColor; border-top-width: 1px; border-top-style: solid;\" valign=\"top\">\n<ul>\n<li><a title=\"Managing the Information Columns - Adding Counts\" href=\"\/help\/managing-information-columns-adding-counts\">Managing the Information Columns &#8211; Adding Counts<\/a><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr class=\"qgkb-articleheader-table-summary\">\n<td style=\"vertical-align: top; border-top: 1px solid #e6e6e6;\"><strong><span style=\"color: #444444;\"><span style=\"line-height: 14px; font-size: 14px;\">Further Information:<\/span><\/span><\/strong><\/td>\n<td style=\"vertical-align: top; border-top: 1px solid #e6e6e6;\">\n<ul>\n<li><a href=\"https:\/\/www.paribuscloud.com\/help\/\">Paribus 365 Help Center Menu<\/a><\/li>\n<li><a href=\"\/help\/paribus-discovery\/faqs\/\">Paribus 365 Data Cleansing FAQs<\/a><\/li>\n<li><a href=\"\/help\/paribus-discovery\/troubleshooting\/\">Paribus 365 Data Cleansing Troubleshooting<\/a><\/li>\n<li><a href=\"\/help\/paribus-discovery\/how-to-guides\/\">Paribus 365 Data Cleansing How-To Guides<\/a><\/li>\n<li><a href=\"\/help\/paribus-discovery\/technical-articles\/\">Paribus 365 Data Cleansing Technical Articles<\/a><\/li>\n<li><a href=\"\/help\/paribus-discovery\/documents\/\">Paribus 365 Data Cleansing Document Library<\/a><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><!-------------------------------------- Article Footer End ---------------------------------------><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-3893\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\"><span>Twitter<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-3893\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\"><span>LinkedIn<\/span><\/a><\/li><li class=\"share-print\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-print sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/\" target=\"_blank\" title=\"Click to print\"><span>Print<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Summary: Some systems hold the codes of picklist fields and not the text value displayed in the CRM table\/entity being cleansed. Article Type: How-To Guide Related Product(s): This article relates to the following products: Paribus 365&#x2122; Data Cleansing Microsoft Dynamics 365 CRM Infor CRM SLX (Saleslogix) Introduction For the reviewers of Paribus 365&#x2122; Data Cleansing &hellip; <a href=\"https:\/\/www.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Managing the Information Columns &#8211; Converting Picklist Codes<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-3893\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\"><span>Twitter<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-3893\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\"><span>LinkedIn<\/span><\/a><\/li><li class=\"share-print\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-print sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/\" target=\"_blank\" title=\"Click to print\"><span>Print<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":17,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false},"categories":[163,134,14,1956,13,23],"tags":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v15.1.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"For the reviewers of Paribus 365\u2122 Data Cleansing Match Results having information columns that speed up the decision are important.\" \/>\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.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Managing the Information Columns - Converting Picklist Codes\" \/>\n<meta property=\"og:description\" content=\"For the reviewers of Paribus 365\u2122 Data Cleansing Match Results having information columns that speed up the decision are important.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/\" \/>\n<meta property=\"og:site_name\" content=\"The Paribus Help Center\" \/>\n<meta property=\"article:published_time\" content=\"2015-02-02T13:44:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-04T10:23:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.qgate.co.uk\/knowledge\/wp-content\/uploads\/2015\/02\/fig1-picklist-300x198.png\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:creator\" content=\"@ParibusDedupe\" \/>\n<meta name=\"twitter:site\" content=\"@ParibusDedupe\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#organization\",\"name\":\"QGate Software Ltd\",\"url\":\"https:\/\/www.paribuscloud.com\/help\/\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/qgate\/\",\"https:\/\/www.youtube.com\/channel\/UCZBmNdUEnRL9RH0ah3US99g\",\"https:\/\/twitter.com\/ParibusDedupe\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.paribuscloud.com\/help\/wp-content\/uploads\/2018\/05\/QGate_logo_4c.png\",\"width\":1808,\"height\":700,\"caption\":\"QGate Software Ltd\"},\"image\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#website\",\"url\":\"https:\/\/www.paribuscloud.com\/help\/\",\"name\":\"The Paribus Help Center\",\"description\":\"Customer Self Help, Paribus events and product news\",\"publisher\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.paribuscloud.com\/help\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.qgate.co.uk\/knowledge\/wp-content\/uploads\/2015\/02\/fig1-picklist-300x198.png\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/#webpage\",\"url\":\"https:\/\/www.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/\",\"name\":\"Managing the Information Columns - Converting Picklist Codes\",\"isPartOf\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/#primaryimage\"},\"datePublished\":\"2015-02-02T13:44:02+00:00\",\"dateModified\":\"2025-06-04T10:23:34+00:00\",\"description\":\"For the reviewers of Paribus 365\\u2122 Data Cleansing Match Results having information columns that speed up the decision are important.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/\"]}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/#webpage\"},\"author\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#\/schema\/person\/27108c9cbbc1840b9f51b9119fdd7cee\"},\"headline\":\"Managing the Information Columns &#8211; Converting Picklist Codes\",\"datePublished\":\"2015-02-02T13:44:02+00:00\",\"dateModified\":\"2025-06-04T10:23:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/#webpage\"},\"publisher\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/managing-information-columns-converting-picklist-codes\/#primaryimage\"},\"articleSection\":\"How-To Guide,Infor CRM,Microsoft Dynamics CRM,Paribus 365,Paribus Discovery,Technical Article\",\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#\/schema\/person\/27108c9cbbc1840b9f51b9119fdd7cee\",\"name\":\"Paribus 365 Team\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/00c6cd7408c3531da38599fd6bccaa5c?s=96&d=mm&r=g\",\"caption\":\"Paribus 365 Team\"},\"sameAs\":[\"http:\/\/www.Paribus365.com\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8hT1P-10N","_links":{"self":[{"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/posts\/3893"}],"collection":[{"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/comments?post=3893"}],"version-history":[{"count":17,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/posts\/3893\/revisions"}],"predecessor-version":[{"id":24204,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/posts\/3893\/revisions\/24204"}],"wp:attachment":[{"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/media?parent=3893"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/categories?post=3893"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/tags?post=3893"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}