Forum Discussion
Data modeling question
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.
The unique record identifier is just a number (ID) as its an OData connection to a SharePoint Online list. So I just use the default ID created when a new item is added to the list.
In order to create the new table with the unique record identifier and (now) 5 columns, do I just multi select and then...?
If the answer is just copying and pasting, how does that second table get refreshed when new items are added?
