Merging two different tables to with some similar columns

Question

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 and in another table has employee ID, title where now I need Employee ID and F.name, L.name & title in on one table.

What would be the best approach for this ?

robiv · Answer

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.

abhireddy · Answer

What if existing table's count is mismatched with newly created table.

Ex: Existing table has 8 columns with 8k records and new table has 3 columns with 6k records. then while importing or merging how can I achieve that these are aligned to correct one.

robiv · Answer

Hmm.&nbsp; Well, this is what I would do.Start with the 'more complete' table.&nbsp; 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&nbsp;will match the title records with the name records, then update the title.&nbsp; The names with no title ID will be skipped and no update will occur.&nbsp;&nbsp;Does this make sense?

robiv · Answer

Again, it is critical that the Employee ID in both tables refers to the same Employee.&nbsp;

abhireddy · Answer

Thank you!Can you please provide example steps to do that? Couldn't able to figure it out!

Forum Discussion

Merging two different tables to with some similar columns

Related Content

Merge Imports

Merging Two Completely Different Tables

Merging 2 Fields into a Formula-Text Field for Reporting Purposes

Add button to create record in different app

Using GetRecords to query a table in a different application?