Forum Discussion

abhireddy's avatar
abhireddy
Qrew Trainee
7 years ago

Merging two different tables to with some similar columns

In an application one table is having employee information and i want to add some more columns with data needs to align with existing information. EX: Existing table has Employee ID, F.name, L.name...
App builders
Tables and fields
RobIV's avatar
RobIV
Qrew Cadet
7 years ago
If the Employee ID of the Employee in the 'name' table represents the Employee ID of the Employee in the 'title' table, I would simply import the 'title' table into the 'name' table.

You would have to add the 'title' field to the 'name' table first, but then it should work like a charm.
RobIV's avatar
RobIV
Qrew Cadet
7 years ago
Hmm. 

Well, this is what I would do.

Start with the 'more complete' table.  So, if you have 8000 employee records with first and last name, and only 6000 with matched titles, I would add the titles to the names.

Quickbase will match the title records with the name records, then update the title.  The names with no title ID will be skipped and no update will occur.  

Does this make sense?