How do I "Write Excel" out of ExampleSet output of "Analyze Sentiment"?

qchung
qchung New Altair Community Member
edited November 2024 in Community Q&A

Hello community experts,

Tweets were collected using "Search Twitter" and the output was sent to "Analyze Sentiment" of AYLIEN. I'm happy about the output, and I want to export it. Is there a way to export the output from "Analyze Sentiment" to an Excel file? "Write Excel" operator seems to expect "out" (from a preceding operator) for its "inp".

Thanks!

Best Answers

  • Telcontar120
    Telcontar120 New Altair Community Member
    Answer ✓

    If you have the output already in an example dataset, it should work.  I just tested the Aylien "analyze sentiment" operator and it works with the "write excel" operator, although it does give a warning (probably because it isn't transferring the correct metadata about its output).  However, if you've done some additional text processing after the "analyze sentiment" operator then you many need to add the "document to data" operator to convert it back to a normal example dataset before using the "write excel" or "write csv" file.  After that it should work fine!  

     

  • qchung
    qchung New Altair Community Member
    Answer ✓

    Thank you, Brian. So, it was a false alarm! And, yes, as you said, it worked just fine despite the warning.

Answers

  • Telcontar120
    Telcontar120 New Altair Community Member
    Answer ✓

    If you have the output already in an example dataset, it should work.  I just tested the Aylien "analyze sentiment" operator and it works with the "write excel" operator, although it does give a warning (probably because it isn't transferring the correct metadata about its output).  However, if you've done some additional text processing after the "analyze sentiment" operator then you many need to add the "document to data" operator to convert it back to a normal example dataset before using the "write excel" or "write csv" file.  After that it should work fine!  

     

  • qchung
    qchung New Altair Community Member
    Answer ✓

    Thank you, Brian. So, it was a false alarm! And, yes, as you said, it worked just fine despite the warning.