Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

filter fields of different language

taher1992
7 - Meteor

Hi guys, 

 

i have a column which has inputs from a various languages. i want to make two outputs one where the language is only english and the other which is not english.

 

 

is there a way of doing this in alteryx

 

7 REPLIES 7
jdunkerley79
ACE Emeritus
ACE Emeritus

Not directly.

 

You could pass the text to Google Translate API to detect language: https://cloud.google.com/translate/docs/detecting-language

 

Happy to put a sample together if that would work for you

taher1992
7 - Meteor

Hi there if you can help make me one as i didnt even know something like this existed - or direct me towards a tutorial on how to make one

Joe_Mako
12 - Quasar

Attached is an example macro, and use of it with a lookup table for the language codes:

 

google detect lang.png

 

based on the documentation at:

https://cloud.google.com/translate/docs/detecting-language

 

follow steps at:

https://support.google.com/cloud/answer/6158862?hl=en

to get an API key

 

You will then have to go to:

https://console.developers.google.com/apis/api/translate.googleapis.com/overview?project=YOUR_PROJEC...

to enable it with a billing account and credit card (use your project id in place of YOUR_PROJECT_ID.

 

 

jdunkerley79
ACE Emeritus
ACE Emeritus

Thanks for putting that together @Joe_Mako

 

taher1992
7 - Meteor

one favour can i ask which i should have entioned earlier is that i have Alteryx 10.5 and i cant seem to open this on that version. is there a workaround for this

Joe_Mako
12 - Quasar
taher1992
7 - Meteor

Thank you - sorry for the delay

Labels