5 Replies Latest reply on Aug 21, 2013 7:56 AM by Steve Martin

    split a field into multiple values and/or groups

    Browne Browne

      Ok, data can be messy some times, and I am now faced with the following:

       

      I have a field containing 3 groups of attributes

      {"keywords":["keywordA","keywordB"],"users":[userA],"geos":[lat-lon1]}

       

      Part 1:

      I would like to build 3 dimensions(or other possibillity) out of this, being keywords, users and geo.

       

      So i can show keyword participation on a map for instance

       

      Part 2:

      as my example shows, 1 keyword field may contain multiple values, on which i would like to analyse seperately

      The good part is, that user and geo will always have only 1 value

       

      I hope somebody knows the answer!

       

      Cheers!

       

      Dave Browne