3 Replies Latest reply: Mar 16, 2015 1:49 PM by Massimo Grossi RSS

    How do I create a string of information from a single field?

      I have individual products that have separate entries in our database for each Category the product is in:

       

      ProductCategory
      A1
      A2
      A3

       

      I want a single entry for this information in a chart I'm building that just separates each Category by a comma. Something more like below. Preferably this would be built in the script so it loads in as it's own field.

       

      ProductCategories
      A1,2,3
      B1,5,10

       

       

      Any suggestions?