Forum Discussion
Compare and replace values in column from another table
Hi, I have a table (TableA) with these columns Province District City Arovia Eastwood Willobrook Arovia Northside Pynville Belloria Greenridge Belloria Westfield Mapel...
amitchandak
Super User
Super UserAnonymous , Try out if this function can help
Power Query Table.AddFuzzyClusterColumn: https://youtu.be/osF1z5kgvMo
thanks but its still not exactly what i want it to achieve.
it doesnt call the correct values from TableB. The only other thing i can think of using the Table.AddFuzzyClusterColumn is to create a separate Transformation Table (TT), but that defeats the purpose, because that would require me to manually enter the data to match it accordingly in the TT.
Also, Table.AddFuzzyClusterColumn is not able to differentiate between City, District and Province. Some Province and District values are in the wrong column.