I have a comma separated text, product of an Enum list.
which corresponds to Key Id’s of another table.
I want to convert it to a referenced List, in order to obtain the data corresponding to each Key Id, promptly the Price column.
It occurred to me to make a Virtual Column [SPLITCOL] with the following expression:
SPLIT ([CSV], “,”)
Then in another column put
[SPLITCOL]. [PRICE]
But it doesn’t allow me to assign a list as a REF type.
How should I do to get other data from the table from a CSV list?
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |