"Urgent help required: Export word list to excel sheet"

RapidQues

Kindly help me.
I want to know how i can export the word list from the result of text mining to an excel sheet.

I have tried to use the "write excel " operator, but it gives error on connection with word output of process.
error message: "expected exampleset".

Thankyou.

RalfKlinkenberg

RapidQues wrote:
I want to know how i can export the word list from the result of text mining to an excel sheet. I have tried to use the "write excel " operator, but it gives error on connection with word output of process. error message: "expected exampleset".

Once you have generated a word list using for example a "Process Documents from Data" or "Process Documents from Files" operator, you can use the "WordList to Data" operator and transform the word list into a standard data table ("Example Set"), which can then be stored to an Excel file using the "Write Excel" operator.

Before writting the word list, you could also sort it using the "Sort" operator and filter it to focus on the top words using the "Example Range Filter". After sorting the words in the desired order, you can for example use the example range from 1 to 20 to deliver the top 20 words according to your sorting order.

Best wishes,
Ralf