Anonymous
7 years agoNot applicable
Status:
New
Bug: cannot fuzzy merge two text columns
Hello I have basically two tables with each one having a field about the country. Both fields are declared as text in the Query Editor. I am trying then to merge these columns fuzzily. In the ...
Anonymous
7 years agoNot applicable
Update: i might have found the solution.
In the query, there was still some "null" in the column Country1. I replaced them with "Others" and it is now working.
But, how come, it is possible to set the data type to text, but the fuzzy merge does not consider it because of the nulls. I think the error message should be clearer.
Cheers. G.