Forum Discussion
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...
any other suggestions? unfortunately that did not work, it still only shows one country per data set
*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?
- hi, i am just working on the same issue. I resolve the issue by creating a supporting table and then link the table based on the PK. You can create a link table using a summarizecolumns functions. In the query editor mode, duplicate your main table query. Only keep the ID and the column that has the country names. Under Transform ribon, select Split Column by delimiter. After spliting step is done, on the left top side just before your first column, you will see a small table icon. Click on it and then select remove duplicates. Then, load your table. Your supporting table will only have unique country names for each product id. After load is done, go to relationship mode and create the link between your new table and old/main one based on product id.
