Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

NLP Sentiment tool in other languages


Hi everyone


I was following the Comparing Sentiment Analysis Algorithms article, but when trying to use the StandfordCoreNLP Sentiment tool I was getting the error "The external program "java" returned an error code: 2", just like in this post, being unable to run Java using the RunCommand.


The solution, posted here, worked fine, being able to solve the problem by wraping the java command in a cmd shell. 


However, I am unable to get the CoreNLP running in other languages,as explained here. Any idea on how to modify the macro to achieve this? I have been toying with the configuration of some Formula tools but I am back to Java errors.



Javi Calvo 





Hi @jcalvo92 


It looks like quite a bit of work needs to be done to get that tool to run with other languages based on the dependencies listed. One alternative would be to run your text through a translation API as part of your workflow to then be run through an English sentiment analysis process. That way you could run the tool as is.


Hi @BrandonB


That’s actually a solid alternative, but it moves the problem to how to translate texts in Alteryx. I am only able to find solutions that use the Cognitive Services Text Translation macro. This uses the same Microsoft paid services than the Cognitive Services Text Analytics macro, which already provides sentiment analysis in multiple languages at the same price.


So instead of paying for a translation, you can pay directly for a sentiment analysis in your language of choice.


The "Comparing Sentiment Analysis Algorithms" article that I mentioned explored different open source solutions, but all of them are in English only, or difficult to adapt to Alteryx.


Do you know an open source solution to translate texts in Alteryx? That would solve the problem.


Thank you for your feedback


I haven't used it yet myself, but there are quite a few free Python libraries that offer free text translation like the following:




Thanks, will have a look at it