Example 4: TD_TextMorph with POS Argument Specified and SingleOuptut Set to 'True' - 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-07-09
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('true')
  POS('noun', 'verb')
  Accumulate('id')
) AS dt order by 1,2;

Result:

id word TD_Morph POS
1 regression regression NOUN
3 better better NOUN
4 datum datum NOUN
7 father father NOUN
8 juniors junior NOUN
9 doing do VERB
10 being being NOUN
11 negating negate VERB
12 yearly yearly NOUN