LDATopicSummary Example | Teradata Vantage - LDATopicSummary Example: OutputByWord ('false') - Teradata Vantage

Input

• ldamodel output table, LDA Example

SQL Call

SELECT * FROM LDATopicSummary (
  ON ldamodel PARTITION BY 1
  USING
  OutputByWord ('false')
  OutputTopicWordNum (10)
) AS dt ORDER BY topicid;

Output

 topicid wordsequence                                                               
 ------- -------------------------------------------------------------------------- 
       0 wipers,would,switch,when,on,recall,windshield,notified,manufacturer,dealer
       1 vehicle,causing,consumer,replaced,which,module,out,control,has,at         
       2 vehicle,manufacturer,would,transmission,problem,when,at,has,also,&        
       3 did,not,deploy,hit,vehicle,side,air,passenger's,bags,mph                  
       4 vehicle,side,car,engine,while,fire,for,from,left,wheel

Download a zip file of all examples and a SQL script file that creates their input tables.