Forum Discussion
Solved
Data modeling question
I'm hoping someone can at least point me in the right direction to do more research. I have a field in my data set that technically a single line text, but has multiple values separated by commas. Ho...
If I assume that you wish to slice on each of those phrases (between commas) - then I'll add to the other replies already posted: your modeling is several steps.
You will first use the split column feature - to set them in their own columns
but then you need to create a new table with your unique record ID and just those columns - and then make that UnPivoted so it is table by itself that has ID in each record and 1 phrase in each record.
This final table needs to be joined back to the original table and is the 'Many' table of a 1:Many relationship.