1 Reply Latest reply: Jun 27, 2011 12:23 PM by crj RSS

    combining columns

    870550
      Hi ! is there any option to combine two picklist column values. In column1 formula, if i write as column1 + column2, its not working. Is there any option to use UNION operator. Then how could two column values(picklist) can be combined, without using combined analysis ? Because i could achieve this, if i use combined analysis. Is there any option to combine columns without using combined analysis. Kindly suggest some ideas for this.

      Edited by: 867547 on Jun 23, 2011 1:01 AM
        • 1. Re: combining columns
          crj
          Could you please clarify if you are trying to concatenate these two picklist values on each row, or if you're trying to show these values on different rows? I suspect you're simply trying to concatenate them on the same row, in which case you can use the concatenation operator (||) between the fields (rather than +). For example, concatenating two picklist fields from the Account object:

          "- Account Custom Attributes".PICK_2 || "- Account Custom Attributes".PICK_19

          If you would like some delimiter between them, you can concatenate that as well:

          "- Account Custom Attributes".PICK_2 || ',' || "- Account Custom Attributes".PICK_19

          If this is not the answer you're seeking, please provide some more details about what you are trying to accomplish.

          Chris