Richard K
Member
Members
Forum Posts: 17
Member Since:
August 4, 2020
August 4, 2020
Offline
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: Andrea Fernandez-Trujillo, Riny van Eekelen, Robert Primmer
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
David M Connelly
Quick Analytics
Peter Craven
Thomas Huybs
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Rick KISA
Jan Elenbaas
Forum Stats:
Groups: 3
Forums: 24
Topics: 6880
Posts: 30159
Member Stats:
Guest Posters: 49
Members: 33706
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —