{"id":21896,"date":"2018-03-21T12:44:53","date_gmt":"2018-03-21T12:44:53","guid":{"rendered":"https:\/\/www.paribuscloud.com\/help\/?p=21896"},"modified":"2025-05-14T14:28:36","modified_gmt":"2025-05-14T14:28:36","slug":"custom-fields-converting-option-sets","status":"publish","type":"post","link":"https:\/\/www.paribuscloud.com\/help\/custom-fields-converting-option-sets\/","title":{"rendered":"Custom fields &#8211; Converting Option Sets"},"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\">This article walks you through converting Option Sets and how you can use them in Paribus 365&#x2122; Data Cleansing.<\/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, Technical Article<\/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;\u00a0Data Cleansing<\/li>\n<li>Microsoft Dynamics 365 CRM<\/li>\n<li>Infor CRM \/ Saleslogix<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><!-------------------------------------- Article Header End ---------------------------------------><\/p>\n<h2><strong>Custom fields &#8211; Converting Option Sets code to text values<\/strong><\/h2>\n<p>Sometimes the field we need is only held as code which references an option set.\u00a0 If it is not possible to retrieve the field value then a SQL CASE statement can be used to convert the values.\u00a0 Example below.<\/p>\n<p><img loading=\"lazy\" class=\"alignnone wp-image-21897 size-full\" src=\"https:\/\/www.paribuscloud.com\/help\/wp-content\/uploads\/2018\/03\/Covert_Option_Set1.png\" alt=\"Converting Option Sets with SQL Case statement\" width=\"532\" height=\"578\" srcset=\"https:\/\/www.paribuscloud.com\/help\/wp-content\/uploads\/2018\/03\/Covert_Option_Set1.png 532w, https:\/\/www.paribuscloud.com\/help\/wp-content\/uploads\/2018\/03\/Covert_Option_Set1-276x300.png 276w\" sizes=\"(max-width: 532px) 100vw, 532px\" \/><\/p>\n<p>When you click on \u201cOK\u201d button you will be prompted with a Dependency Check pane to advise of any associated objects that will be affected &gt; Confirm by clicking on \u201cYes\u201d button.<\/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>\u00a0Related 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 href=\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-custom-fields\/\">Paribus 365 Data Cleansing Custom Field articles<\/a><\/li>\n<li><a href=\"https:\/\/www.paribuscloud.com\/help\/paribus-Discovery\/how-to-guides\/\">Paribus 365 Data Cleansing How-To articles<\/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 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-21896\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/custom-fields-converting-option-sets\/?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-21896\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/custom-fields-converting-option-sets\/?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\/custom-fields-converting-option-sets\/\" 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: This article walks you through converting Option Sets and how you can use them in Paribus 365&#x2122; Data Cleansing. Article Type: How-To Guide, Technical Article Related Product(s): This article relates to the following products: Paribus 365&#x2122;\u00a0Data Cleansing Microsoft Dynamics 365 CRM Infor CRM \/ Saleslogix Custom fields &#8211; Converting Option Sets code to text &hellip; <a href=\"https:\/\/www.paribuscloud.com\/help\/custom-fields-converting-option-sets\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Custom fields &#8211; Converting Option Sets<\/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-21896\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/custom-fields-converting-option-sets\/?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-21896\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/custom-fields-converting-option-sets\/?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\/custom-fields-converting-option-sets\/\" 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,164,14,1956,13,15,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=\"This Help Center article walks you through the process for converting Option Sets and how you can use them in Paribus 365 Data Cleansing.\" \/>\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\/custom-fields-converting-option-sets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Custom fields - Converting Option Sets - The Paribus Help Center\" \/>\n<meta property=\"og:description\" content=\"This Help Center article walks you through the process for converting Option Sets and how you can use them in Paribus 365 Data Cleansing.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.paribuscloud.com\/help\/custom-fields-converting-option-sets\/\" \/>\n<meta property=\"og:site_name\" content=\"The Paribus Help Center\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-21T12:44:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-14T14:28:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.paribuscloud.com\/help\/wp-content\/uploads\/2018\/03\/Covert_Option_Set1.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\/custom-fields-converting-option-sets\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.paribuscloud.com\/help\/wp-content\/uploads\/2018\/03\/Covert_Option_Set1.png\",\"width\":532,\"height\":578,\"caption\":\"Convert Option Sets with SQL Case statement\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/custom-fields-converting-option-sets\/#webpage\",\"url\":\"https:\/\/www.paribuscloud.com\/help\/custom-fields-converting-option-sets\/\",\"name\":\"Custom fields - Converting Option Sets - The Paribus Help Center\",\"isPartOf\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/custom-fields-converting-option-sets\/#primaryimage\"},\"datePublished\":\"2018-03-21T12:44:53+00:00\",\"dateModified\":\"2025-05-14T14:28:36+00:00\",\"description\":\"This Help Center article walks you through the process for converting Option Sets and how you can use them in Paribus 365 Data Cleansing.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.paribuscloud.com\/help\/custom-fields-converting-option-sets\/\"]}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/custom-fields-converting-option-sets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/custom-fields-converting-option-sets\/#webpage\"},\"author\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#\/schema\/person\/27108c9cbbc1840b9f51b9119fdd7cee\"},\"headline\":\"Custom fields &#8211; Converting Option Sets\",\"datePublished\":\"2018-03-21T12:44:53+00:00\",\"dateModified\":\"2025-05-14T14:28:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/custom-fields-converting-option-sets\/#webpage\"},\"publisher\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/custom-fields-converting-option-sets\/#primaryimage\"},\"articleSection\":\"How-To Guide,Infor CRM,Microsoft Dynamics 365,Microsoft Dynamics CRM,Paribus 365,Paribus Discovery,Saleslogix,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-5Ha","_links":{"self":[{"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/posts\/21896"}],"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=21896"}],"version-history":[{"count":9,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/posts\/21896\/revisions"}],"predecessor-version":[{"id":23967,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/posts\/21896\/revisions\/23967"}],"wp:attachment":[{"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/media?parent=21896"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/categories?post=21896"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/tags?post=21896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}