
Richard K
Member
Members

Forum Posts: 15
Member Since:
August 4, 2020
August 4, 2020

I'm pulling data into a query from a webpage and attempting to merge it with an existing table in order to add a "foreign_Key" column.
The issue i'm having is that sometimes different names are used in the column I use to merge the tables and this results in a null result.
An example of this is that the name from the webpage can sometimes be "Alberts" or "Alberts Park" and in my table it is listed as "Alberts Park" so when the merge compares the two columns I get a null result for those that are just "Alberts".
Is there a way around this? The only way I can see of fixing it is to have duplicated entries in the key table with the different name variations.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Velouria
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
Jessica Stewart: 204
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Murat Hasanoglu
Brett Dryland
Saeed Aldousari
Bhuwan Devkota
Kathryn Patton
Maria Conatser
Jefferson Granemann
Glen Coulthard
Nikki Fox
Rachele Dickie
Forum Stats:
Groups: 3
Forums: 24
Topics: 6222
Posts: 27291
Member Stats:
Guest Posters: 49
Members: 31913
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
