July 17, 2018
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.