STRTOK_SPLIT_TO_TABLE

Database
Enthusiast

STRTOK_SPLIT_TO_TABLE

Hi

I have been researching the STRTOK_SPLIT_TO_TABLE at:

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1145_111A/Stri...

​Is there away to add more columns to the select statement output along with the tokens. If so how does the syntax go?

Tags (1)
1 REPLY
Teradata Employee

Re: STRTOK_SPLIT_TO_TABLE

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.)