Advanced Search

Announcement

Collapse
No announcement yet.

Cluster word list export

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Cluster word list export

    Is there any way to export or get a report of the words that are shown in an analytics cluster?

  • #2
    Hi ogerroll,

    There's not currently a report that outputs just the cluster words, but it is something you can pull relatively easily via SQL.

    First, note the exact name of the cluster for which you want the word list. Next, .ocate the appropriate ADD Review (Eclipse) case database in your ADD config database. Finally, run this query against the case database:

    Code:
    SELECT DISTINCT TC.ConceptWord
    FROM DataAnalytics.TopicConcept TC
    JOIN DataAnalytics.Topic T
    ON TC.TopicId = T.TopicId
    JOIN DataAnalytics.AnalyticsRun AR
    ON (T.AnalyticsRunId = AR.AnalyticsRunID
    AND AR.AnalyticsRunName = 'XXX') --Replace XXX with exact name of cluster
    WHERE ConceptWord <> 'Unclustered Documents'
    With custom reports for ADD, you can technically add this as a report. However, that takes a bit more legwork and is something outside the scope of support; if you're interested, our services team could likely assist in doing so (though it would be a chargeable service). You can also find instructions on how to do it yourself in the ADD Administrator Guide.
    Last edited by Joshua DeLapp; 4 weeks ago.

    Comment

    Working...
    X