Example 3: TD_TextMorph with POS Argument Specified and 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')
  POS('noun', 'verb')
  Accumulate('id')
) AS dt order by 1,2;

Result:

id word TD_Morph POS
1 regression regression NOUN
3 better better VERB
3 better better NOUN
4 datum datum NOUN
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 NOUN