TextMorph Example: SingleOutput ('false') - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

Input

SQL Call

SELECT * FROM TextMorph (
  ON words_input
  USING
  WordColumn ('word')
  SingleOutput ('false')
  Accumulate ('id', 'word')
) AS dt ORDER BY id;

Output

 id word       morph      pos  
 -- ---------- ---------- ---- 
  1 regression regression noun
  2 roger      roger      NULL
  3 better     well       adv 
  3 better     well       adj 
  3 better     good       adj 
  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
 11 negating   negate     verb
 12 yearly     yearly     noun
 12 yearly     yearly     adv 
 12 yearly     yearly     adj

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.