I’m having a mental block with this one.
Imagine I have a table containing “things”. Something like this:
In a second table, I have a column that contains a joined list of “keys”. Like so:
Important point to note is that my joined list contains duplicate keys.
What I want to do is transform that joined list of keys into a joined list of values, whilst maintaining the duplicates. So the end result should look like:
I can create a Spilt Text column, then use that to create a multi-relation, and then use another joined list to get the values through that relation, BUT… I lose the duplicates.
I feel like this should be trivial. What am I missing?