Fuzzy Logic|Power Query|Excel Forum|My Online Training Hub

Hi I want to merge two querys by two columns both are set as Text although one does contain just numbers (it has to be padded to 8 places).

The fuzzy merge works when using just the Desc column but as soon as I add the UPC column it complains about only supporting Text columns even though its definitely set as Text

Expression.Error: We only support text columns for fuzzy join operations. The column 'UPC' is not of type text.

The fuzzy match is used because of case sensitivity in the Desc column but if I dont use the UPC it misses some of the products because of differing names with duplicate UPC.

regards

John