Forum Discussion

Maexchen's avatar
Maexchen
Frequent Visitor
8 years ago

Data shaping for shape maps

Hi,   I have a dataset that contains rows with Products (each with a unique identifier) which in one column contains all the countries where this product is available - this field is comma delimina...
Need Help
jthomson's avatar
jthomson
Solution Sage
8 years ago

I tried to split the country field into multiple columns but I can only use one column in the shape map visual. (also some products have >30 countries so this a bit messy)

 

Did you try to unpivot the multiple columns into one once you split them?

  • Maexchen's avatar
    Maexchen
    Frequent Visitor
    8 years ago

    Hi,

     

    no I haven't but I will try. However, will that not multiply all the rows? I have another visual that counts another column, which will then show me too many(?), although I can probably get around that by counting (distinct).

     

    I'll try that

    • Maexchen's avatar
      Maexchen
      Frequent Visitor
      8 years ago

      any other suggestions? unfortunately that did not work, it still only shows one country per data set

      • Maexchen's avatar
        Maexchen
        Frequent Visitor
        8 years ago

        *bump*

         

        unpivoting the data makes them all to be in one column but therefore of course adds a lot of rows. Is there an option to create a linked table?