"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

RapidQues

Thank you  Ralf 

akin_alan

I did exactly that... Read Document->Process Documents-> Wordlist to Data-> Write Excel -> result .......All ends with green checkmarks and no errors... perfect..  With that, no data and no excel file is generated ... hours of troubleshooting but all with the same results. - Alan

kypexin

Hi @akin_alan

 

A very quick way to troubleshoot a situation like that will be putting breakpoint after each operator and this way you can control if each operator actually delivers an output as expected. So if there's a problem you can see where exactly in the process something goes wrong.