fuzzy match issue

[lilyyangadsk]

can help check why fuzzy match not able to match japanese and chinese charater? Here is example of Japanese char. thank you

[FrederikE]

Hey @lilyyangadsk,

With it's classic way of working the Fuzzy Match Tool can't achive what you ask for, since the algorithms behind it are base on latin characters. 

But you can select "Japanenese Text" as the Match Style - This way it works with japanese characters instead, 

[Yoshiro_Fujimori]

@lilyyangadsk ,

What is the your Designer version?

Fuzzy Matching for Japanese is supported from 2022.3 (the most recent version).

https://help.alteryx.com/release-notes/designer/designer-20223-release-notes

Fuzzy Match Support for Japanese
We’ve added support for Japanese to the Fuzzy Match tool. You can now apply predefined match styles, that account for Japanese orthography, to Japanese addresses, names, or text.

If you are already upgraded to 2022.3 and still having trouble, please check if you configure "Match Style" for Japanese names.

Good luck.

[lilyyangadsk]

my version has to be 2022.1.1 as server in our company is at this version. 

[Yoshiro_Fujimori]

@lilyyangadsk ,

In that case, you would still have some options;

1. Upgrade your Designer anyway

Easy, but you cannot publish your workflow to the Server.

You still can download from the Server.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Alteryx-Designer-vs-Alteryx-Server-Ver...

2. Wait for the Server version up

Easy, but it may take time.

2022.1.1 end of support is 2024-05-04, so you may have to wait a year+ if your IT team is not agile.

(https://help.alteryx.com/release-notes/server/server-20221-release-notes)

3. Write Python code in Python tool

Hard if you do not write Python, but you can do it yourself.

https://stackoverflow.com/questions/34523191/fuzzy-matching-japanese-strings-in-python

[lilyyangadsk]

does new version fuzzy match also support chinese character? 

[Yoshiro_Fujimori]

Release note says:

Fuzzy matching only works with Latin and Japanese character sets, and some of the match capabilities are only compatible with English or Japanese. Fuzzy matching accounts for various differences in Japanese orthography, such as half-width and full-width characters, hiragana and katakana, kana modifiers, and old kanji forms.

[lilyyangadsk]

thank you very much!  i have a question, these days i got issue with fuzzymatch tool, i used to be able to at least match certain level of chinese and japanese character, now it totally not work. i tried to figure out reason, i found attached error, that i can't find temp.csv file. 

but if i copy and paste the fuzzymatch icon from other workflow i downloaded from community, it works a few but not very. Do you know is it because of attached issue? 

[Yoshiro_Fujimori]

As double byte character sets are not supported on your Desinger version, I cannot help you.

You may try to submit a case to Alteryx support, but I'm not sure if they have an answer with the same reason.