Example 5: TD_TextMorph with POSTagColumn Argument Specified - 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™

Input

id word pos_tag
3 born VBN
5 8 CD
6 august NN
7 1981 CD
9 is VBZ
10 a DT
11 greatest JJS
12 tennis NN
13 player NN
14 , O
15 who WP
17 been VBN
18 continuously RB
19 ranked VBN
20 inside IN
21 the DT
22 top JJ
23 10 CD
24 since IN
25 october JJ
26 2002 CD
27 and CC
28 has VBZ
29 won VBN
30 wimbledon NN
31 , O
33 , O
34 australian JJ
35 and CC
36 frenchopen JJ
37 titles NNS
38 multiple JJ
39 times NNS
32 usopen JJ
16 has VBZ
8 , O
4 on IN
2 federer NN
1 roger NN

Query

SELECT * FROM TD_TextMorph (
    ON pos_input as inputTable
    USING
    WordColumn ('word')
    POSTagColumn ('pos_tag')
    Accumulate ('id', 'pos_tag')
  ) AS dt;

Output

id pos_tag word TD_Morph POS
1 NN roger roger NOUN
2 NN federer federer NOUN
3 VBN born bear VERB
4 IN on on NULL
5 CD 8 8 NULL
6 NN august august NOUN
7 CD 1981 1981 NULL
8 O , , NULL
9 VBZ is be VERB
10 DT a a NULL
11 JJS greatest great ADJ
12 NN tennis tennis NOUN
13 NN player player NOUN
14 O , , NULL
15 WP who who NULL
16 VBZ has have VERB
17 VBN been be VERB
18 RB continuously continuously ADV
19 VBN ranked rank VERB
20 IN inside inside NULL
21 DT the the NULL
22 JJ top top ADJ
23 CD 10 10 NULL
24 IN since since NULL
25 JJ october october ADJ
26 CD 2002 2002 NULL
27 CC and and NULL
28 VBZ has have VERB
29 VBN won win VERB
30 NN wimbledon wimbledon NOUN
31 O , , NULL
32 JJ usopen usopen ADJ
33 O , , NULL
34 JJ australian australian ADJ
35 CC and and NULL
36 JJ frenchopen frenchopen ADJ
37 NNS titles title NOUN
38 JJ multiple multiple ADJ
39 NNS times time NOUN