Forum Discussion
Simple data cleaning (split columns that contain multiple values)/data modelling question
Hello everybody, I frequently run into the same issue that I have a solution for but I wonder if there are better ways or best practices. Image one column contains several values per row. That's ...
Anonymous
If I am understand your question, your model kind of does what I would suggest. Your color table only needs to contain the color, split into a row for each like you have it, and the ID. Then you link it to your upload table, like you have it with bi-directional. Then you can sum the value from the upload table and show the breakdown by color from the color table.
Ha! And then, if a wanted to add a slicer for the color, I would add it from the color table.
In general, I can have however many dimension tables, and combine it with the value column from the original upload table, right?
Ok, I was close. Thank you 🙂