Excel Forum

Fuzzy Logic

John Langham-Service

Member

Members

Forum Posts: 51

Member Since:
July 17, 2018

Offline

July 28, 2021 - 2:39 am

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

Philip Treacy

Admin

Forum Posts: 1518

Member Since:
October 5, 2010

Offline

July 28, 2021 - 8:53 am

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

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Valentyn Kristioglo, Tiffany Kang, stuart burge

Guest(s) 11

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 871

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

Jessica Stewart: 205

A.Maurizio: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

stuart burge

Bruce Tang Nian

Scot C

Othman AL MUTAIRI

Misael Gutierrez Sr.

Attif Ihsan

Kieran Fee

Murat Hasanoglu

Brett Dryland

Saeed Aldousari

Forum Stats:

Groups: 3

Forums: 24

Topics: 6223

Posts: 27294

Member Stats:

Guest Posters: 49

Members: 31919

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen