Example 1: TD_TextMorph with 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-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('True')
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 NOUN
4 datum datum NOUN
5 quickly quickly ADV
6 proud proud ADJ
7 father father NOUN
8 juniors junior NOUN
9 doing do VERB
10 being being NOUN
11 negating negate VERB
12 yearly yearly NOUN