Alteryx Designer Desktop Discussions

dataMack · ‎10-14-2015

Has anyone leveraged the Natural Language Toolkit dictionaries (developed for Python) as part of a Naive Bayes classification for text sentinment analysis in Alteryx? Looking for how to setup those dictionaries for the training set.

NeilR · ‎10-14-2015

I have not tried that exactly, but wanted to alert you to a sentiment analysis tool available on the gallery here. It uses a Microsoft API which is free up to 10,000 transactions per month (and the macro sends batches of 1,000 records, so you might be able to get away with 10,000,000 records per month).

dataMack · ‎10-14-2015

Appreciate that suggestion- will give it a try!

dataMack · ‎10-22-2015

Thanks again Neil. Wanted to let you know I tried it out and it worked like a charm. I used the twitter search connector to download all the #data15 tweets from the Tableau conference and ran them through the Azure ML.

It was a total of 17,000 tweets and the AzureML text macro ran and scored themin just 21 seconds- amazing!

Only thing I'm confused about is the 'batching'. You mentioned that the macro would batch records in groups of 1,000. So I would have expected that i would have used 17 of the 10,000 free calls of the service for the month. But when I checked this morning, my 10,000 calls are totally depeleted and I have to wait until next month (or buy more).

This is my first foray into Azure, so appreciate any explanation on what happened there.

NeilR · ‎10-22-2015

The Microsoft data plan page currently states: "A transaction is one request that returns one page of results. Retrieving multiple pages will result in multiple transactions executed." I mistakenly interpreted that to mean a batch of 1,000 records would count as a single transaction.

I reached out to Microsoft - they quickly responded that each record counts as a single transaction and they will update their documentation to make this clearer. Go Microsoft support!

dataMack · ‎10-23-2015

Very much apppreciate you contacting MS to clarify.

I guess I blew through my 1 month free allocation in 1 shot then, but at least it was for a good viz!

nathan_fredette · ‎08-04-2016

Hi,

I downloaded the API and I am not sure how to test my data set against the text analysis. Thanks for the help.

NeilR · ‎08-04-2016

I'd recommend downloading the Alteryx Starter Kit for Microsoft. Once installed, it contains an example workflow showing how to use the Sentiment Analysis tool.

MizunashiSinayu · ‎01-10-2017

Hi, thank you for the explanation..

I just tried this one wonderful macro today, however, I got this error:

Error: AzureMLTextAnalytics (5): Tool #76: Microsoft API error... HTTP/1.1 403 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>
<title>403 - Forbidden: Access is denied.</title>
<style type="text/css">

</style>
</head>
<body>
<div id="header"><h1>Server Error</h1></div>
<div id="content">
<div class="content-container"><fieldset>
<h2>403 - Forbidden: Access is denied.</h2>
<h3>You do not have permission to view this directory or page using the credentials that you supplied.</h3>
</fieldset></div>
</div>
</body>
</html>