5 Replies Latest reply on Sep 19, 2018 1:42 PM by Jess Anastasia

    Split dimension question

    Jess Anastasia

      Hello everyone!

       

      Looking for some help with an issue that I have. I've tried several things but not having much luck. Looking for advice on how to best approach this.

       

      I have a data source that looks like the below. It currently is an Excel worksheet, but I'm working on getting this data into a database but it will still look the same.

       

      Support IDProductsQuotesLocations
      SID001Product1; Product214
      SID002Product2; Product422
      SID003Product112
      SID004Product3; Product436
      SID005Product212
      SID006Product316

       

      What is the best way to split the products column? I know that it would be preferable to have "tall" data as opposed to "wide" data, but if I create multiple rows to break out the products then the Quotes and Locations column gets counted multiple times, which will inflate those numbers. If I split the column, how should I combine them to create one Product column to use for Product trends?

       

      Any help would be appreciated.

       

      I've attached a sample workbook. I'm using 10.4.1.