TextTagger Example 3: TaggingRules, Dictionary File - Teradata Vantage

This example uses this dictionary file, keywords.txt:

floods
tsunamis
Roger
Nadal
India
Pakistan
England
Australia

Input

• Input table: text_inputs, as in TextTagger Example 1: TaggingRules, Rules

SQL Call

SELECT * FROM TextTagger (
  ON text_inputs
  USING
  TaggingRules ('dict(content, "keywords.txt", 1,) AND
          equal(titles, "Chennai Floods") AS Natural-Disaster',
         'dict(content, "keywords.txt", 2,) AND
          equal(catalog, "sports") AS Great-Sports-Rivalry '
  )
  Accumulate ('id')
) AS dt ORDER BY id;

Output