TextMorph Example 4: POS ('noun', 'verb'), SingleOutput ('true') - Teradata Vantage

Input

• Input table: words_input, as in TextMorph Example 1: SingleOutput ('true')

SQL Call

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

Output

With SingleOutput ('true'), the words better and father appear in the output table only as nouns.