Problem with sentiment analysis

The warning is telling you that the data you are passing from Read Excel operator to the Analyze Sentiment operator is not in document form (i.e. DOC). You will likely need to use a Data to Documents operator betwen the two.

hello @regina_moser welcome to the community! I'd recommend posting your XML process here (see https://youtu.be/KkgB5QXWXJ8 and "Read Before Posting" on right when you reply) and attach your dataset. This way we can replicate what you're doing and help you better.

Scott

Thank you @Thomas_Ott. I added the Operator you recommended to me but now when I run the process it works until the Analyse Sentiment Operator but it doesn't finish. When I end the process I get the message you can see in the Screenshot. Maybe you can help me one more time?

Thank you in advance.

That might because of something on the Aylien side. Not sure what the warning means, did you use up all your API limit?

Hello @sgenzer I followed the tutorial you recommended to me. Here's my XML process.

<?xml version="1.0" encoding="UTF-8"?><process version="8.0.001">
  <operator activated="true" class="read_excel" compatibility="8.0.001" expanded="true" height="68" name="Read Excel" width="90" x="112" y="34">
    <parameter key="excel_file" value="/Users/reginamoser/Desktop/jan17-sep17.xls"/>
    <parameter key="sheet_number" value="1"/>
    <parameter key="imported_cell_range" value="A1:J8860"/>
    <parameter key="encoding" value="SYSTEM"/>
    <parameter key="first_row_as_names" value="false"/>
    <list key="annotations">
      <parameter key="0" value="Name"/>
    </list>
    <parameter key="date_format" value=""/>
    <parameter key="time_zone" value="SYSTEM"/>
    <parameter key="locale" value="German (Austria)"/>
    <list key="data_set_meta_data_information">
      <parameter key="0" value="RATING_ID.true.integer.attribute"/>
      <parameter key="1" value="TITLE.true.polynominal.attribute"/>
      <parameter key="2" value="FREE_TEXT.true.polynominal.attribute"/>
      <parameter key="3" value="BUSINESS_KEY.true.polynominal.attribute"/>
      <parameter key="4" value="VERIFIED.true.integer.attribute"/>
      <parameter key="5" value="REASON.true.polynominal.attribute"/>
      <parameter key="6" value="BRAND.true.polynominal.attribute"/>
      <parameter key="7" value="OVERALL_RATING.true.integer.attribute"/>
      <parameter key="8" value="RECOMMEND.true.integer.attribute"/>
      <parameter key="9" value="VIN.true.polynominal.attribute"/>
    </list>
    <parameter key="read_not_matching_values_as_missings" value="true"/>
    <parameter key="datamanagement" value="double_array"/>
    <parameter key="data_management" value="auto"/>
  </operator>
</process>
<?xml version="1.0" encoding="UTF-8"?><process version="8.0.001">
  <operator activated="true" class="text:data_to_documents" compatibility="7.5.000" expanded="true" height="68" name="Data to Documents" width="90" x="313" y="34">
    <parameter key="select_attributes_and_weights" value="false"/>
    <list key="specify_weights"/>
  </operator>
</process>
<?xml version="1.0" encoding="UTF-8"?><process version="8.0.001">
  <operator activated="true" class="com.aylien.textapi.rapidminer:aylien_document_sentiment" compatibility="0.2.000" expanded="true" height="82" name="Analyze Sentiment" width="90" x="447" y="34">
    <parameter key="connection" value="Aylien"/>
    <parameter key="sentiment_mode" value="document"/>
  </operator>
</process>

Maybe you can help me now?

thank you in advance.

Best regards,

Regina

hmm that's not valid XML code. Did you just copy and paste the whole thing once?  Maybe please try again?

Scott

Don't select the process, copy and paste. Enable your XML view, then select the actual XML code, copy and paste here. 

I finally managed it to quit the process successfully.

Now I have one more question, is it possible to make an excel export from the results?

I've got IOObjectCollection as a result.

Thank you in advance & best regards,

Regina

hi @regina_moser - sure you can. Just use Documents to Data, followed by Write Excel.

Scott