filter fields of different language

[taher1992]

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

[jdunkerley79]

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]

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]

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

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]

Thanks for putting that together @Joe_Mako

[taher1992]

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 · Accepted solution]

Can you open the attached files? I used the technique from https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Adjusting-Alteryx-Files-for-Different-Versio...

[taher1992]

Thank you - sorry for the delay