4 Replies Latest reply on Feb 10, 2016 7:40 AM by Adam Crahen

    Is a custom split possible given the following scenario?

    Adam Ackerman

      I have a dimension that includes differing geographic elements separated by commas.  Some records will have "State,Country" and others will have "County,State,Country".  There is also the possibility of City populating prior to the County.  Is there a way to split this into separate country, state, county, and city dimensions?

       

      Here is an example:

       

       

      If this isn't possible, any advice on manipulating the source data?  I am using the JSON web data connector and connecting to the GDELT API.

       

      Thanks!

       

      Adam