I have been researching the STRTOK_SPLIT_TO_TABLE at:
Is there away to add more columns to the select statement output along with the tokens. If so how does the syntax go?
You would use the passed-through "key" value to join the result back to the input table, in order to pick up more columns from the original row.
(Which may require first creating a unique integer key column, if you don't already have one.)