Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
600
Views
Topic starter
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
Posted : 28/07/2021 12:39 pm
Hi John,
If the UPC column is text then I don't know why PQ is complaining that it isn't.
Can you supply a file?
Regards
Phil
Posted : 28/07/2021 6:53 pm
