Error while trying to use Fuzzy Merge

[Anonymous]

Hello everyone

I'm trying to Use Fuzzy Merge, but I get the error message "transformation rules with an empty string are not allowed" (please see attached file)

I have 3 tables:
1. not classified - internal search terms ther have not yet been classified to any department
2. Expected - a list of around 45 departments
3. FromTo - a sample of over 250,000 terms already assigned to a department

All the fields have been imported as text and I tried to make sure to add the "remove blank" from all lines in the Table FromTo.

Any thoughts on what could be the issue?

Thank you for your support

Luís Marcelino

[v-chuncz-msft]

@Anonymous 

You may refer to the post below to remove empty.

https://community.powerbi.com/t5/Desktop/quot-Remove-blank-rows-quot-doesn-t-seem-to-be-working-and-other/td-p/232578

[Coyote_EU]

Just an idea:

It did not went away for me until I deleted all empties of my input tables ( not the From-To table tough!) exactly as Anonymous advised!

Good Luck!