Example 2: TD_TextMorph with SingleOuptut set to 'False' - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-04-01
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢
SELECT * FROM TD_TextMorph (
  ON words_input as inputtable
  USING
  WordColumn('word')
  SingleOutput('false')
  Accumulate('id')
) AS dt order by 1,2;

Result:

id word TD_Morph POS
1 regression regression NOUN
2 Roger Roger NULL
3 better better VERB
3 better well ADV
3 better good ADJ
3 better well ADJ
3 better better NOUN
4 datum datum NOUN
5 quickly quickly ADV
6 proud proud ADJ
7 father father NOUN
7 father father VERB
8 juniors junior NOUN
9 doing do VERB
10 being be VERB
10 being being NOUN
11 negating negate VERB
12 yearly yearly ADV
12 yearly yearly ADJ
12 yearly yearly NOUN