We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How can I count cells that have language different than English

AlanoudF
7 - Meteor

How can I count cells that have language different than English

2 REPLIES 2
suby
11 - Bolide

Please provide the Input Dataset.

FinnCharlton
13 - Pulsar

@AlanoudF it depends which other languages are in your dataset. For languages with different alphabets (Cyrillic, Japanese etc.) you can simply flag those characters. If you want to distinguish languages that both use Latin characters, this will be a lot harder. You could look for characters that never appear in English (like è, ö etc.), or use a lookup table of English words to compare to. As @suby says, if you can provide some sample dataset we can give some better advice.

Labels
Top Solution Authors