cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Knowledge Base

Definitive answers from Designer experts.

The 'How to Guide' to Cognitive Services Text Analytics Macro

Alteryx
Alteryx

The 'How to Guide' to Cognitive Services Text Analytics Macro 

 

As Microsoft continues to grow it's Machine Learning capabilities, Alteryx is following suit and has built a new connector taking advantage of Microsoft's Cognitive Text Analytics API.

 

The new Cognitive Services Text Analytics Macro will replace the AzureML Text Analytics Macro, keeping sentiment analysis and key phrase extraction, while also adding Language and Topic detection.

 

To use this macro you will need to create a Microsoft Account, as well as signing up to the Microsoft Azure Account.

 

Sign in or create a Microsoft Azure Account and this should take you to the Azure portal. You will need to click on 'Create a resource' and search for 'Text Analytics'. 

 

1.PNG

 

You can then click 'create' in the bottom right corner. 

 

 

 You will need to set up a subscriptions if you haven't already. Once you set up an account, you can return to this stage and continue.

 

Once you have set up a subscription you will be able to create an application by filling out the following window. Hot 'Create once you are finished and this prompt azure to deploy this application (This may take a minute - you should see it in the top right of the web browser).

 

3.PNG

 

You can then click on the notification tab and Pin to Dashboard then go to resource.

 

4.PNG

 

Once you have done this you should see the screen below: (If you don't please refresh or sign in & out of cognitive services until you see the information you added above within the information ribbon below). 

 

5.PNG

Click on keys, then copy and Paste them into the Cognitive Services Macro and select your field and type of text analysis.

 

Common Errors:

 

Error: Invalid subscription key

 

This error tends to occur because the account hasn't fully been processed by Microsoft.

 

Solution: Please log in & out of Azure, verify the information looks correct and then copy and paste the key into Alteryx.

 

Azure Error.png

  

Best,

 

Jordan Barker

Solutions Consultant

Comments
Alteryx Certified Partner
Alteryx Certified Partner

Hi @JordanB the new process generates 2 keys and neither seem to work in the macro? Any advice?

Cheers,

Joe

Alteryx
Alteryx

Hi @joe_lipski

 

Have you set this up on Azure dashboard as well? I went through the process of setting this up through the text Analytics website, but I also needed to set up Azure and sign up for a free account.

 

You should then be able to add the account (Screen below)

1.png

 

Once I made sure my account was Active and not Preview, I had to log in and out of the Azure dashboard site! The account then seem to take hold and I chose Key 1.

 

If you have just set up the account I would recommend logging in and out and using Key 1 again.

 

Keep me updated.

Alteryx Certified Partner
Alteryx Certified Partner

@JordanB All working now! Think it was just a case of logging out and logging back in! Thanks!

Meteoroid

@JordanB I get the error "The authorization type you provided is not supported. Only basic and OAuth are supported". My account shows active and both keys generate the same error. Any ideas? Thank you.
Capture.JPG

 

 

Alteryx
Alteryx

Hi @nathan_fredette

 

Can you refresh (logoff) Azure on your webpage as we have seen the keys sometime take a while to take hold on the site. 

 

Can you then insert a new cognitive tool into the canvas and try again.

 

Best,

 

Jordan Barker

Solutions Consultant

Alteryx Certified Partner

Thanks for this @JordanB 

 

It worked perfectly for me first time.

Alteryx
Alteryx

Hi Jordan,

 

It looks like Azure switched up the marketplace and I no longer see the text analytics API when I search? I've been digging and haven't been able to figure out the new workaround. Could you please advise?

 

Thanks,

Mike

 

@DillonA

@AshtonW

@ChadM

Meteor

Michael, I was just trying to get this working today, and ran into the same issue myself.  Whenever I search for Cognitive Services APIs, the only thing I get in my results is Azure Search.  If anyone's got the fix, I'm in the market for it!

Alteryx Certified Partner
Alteryx Certified Partner

Hi @MichaelSu & @paulb1

 

I was actually helping @Treyson with this at Inspire last week and you need to:

 

  1. Log into: https://portal.azure.com/
  2. Click Crete a Resource
  3. Search "Text Analytics"
  4. Click Create and then fill in the details
  5. It can take about 10 minutes for you key to become active so grab yourself a drink once you've created.

 

Hope that helps!

Meteor

Thanks Joe, I was able to get it to work using Translator Text API.  Do you know what the difference is between the two?

Alteryx Certified Partner
Alteryx Certified Partner

Not from an Azure stand point, but I know that you have the option to do Translation in the Alteryx macro, so I assume they probably use the same key - I don't know if the free limits or pricing are different but it might be worth investigating.

Alteryx
Alteryx

Yes, that did the trick. Thank you @joe_lipski !!

Bolide
Bolide

Can confirm. @joe_lipski did help me last week. It was glorious.

Alteryx
Alteryx

All the article has now been updated. Thanks Joe for the steps