Discussions

Expand all | Collapse all

Merging two different tables to with some similar columns

  • 1.  Merging two different tables to with some similar columns

    Posted 05-29-2018 23:07
    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 ?


  • 2.  RE: Merging two different tables to with some similar columns

     
    Posted 05-30-2018 00:02
    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.


  • 3.  RE: Merging two different tables to with some similar columns

    Posted 05-30-2018 00:42
    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.


  • 4.  RE: Merging two different tables to with some similar columns

     
    Posted 05-30-2018 00:49
    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?


  • 5.  RE: Merging two different tables to with some similar columns

     
    Posted 05-30-2018 00:53
    Again, it is critical that the Employee ID in both tables refers to the same Employee. 


  • 6.  RE: Merging two different tables to with some similar columns

    Posted 05-30-2018 03:25
    Thank you!

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


  • 7.  RE: Merging two different tables to with some similar columns

     
    Posted 05-31-2018 23:47
    Sorry for the delay in response.  I've been out-of-pocket for a bit.

    So, I guess I should clarify that you will import the data into a table from an external spreadsheet.  

    Let me see if I can go draw a picture or something to help.



  • 8.  RE: Merging two different tables to with some similar columns

     
    Posted 05-31-2018 23:50
    During the import process, you will be asked about which fields to import.  You will only need to use the ID and Title field in the spreadsheet.  I would not include the First and Last names as you may overwrite those fields with blank data.  

    Does any of this help?


  • 9.  RE: Merging two different tables to with some similar columns

    Posted 05-31-2018 23:54
    Note that there us an assumption here that the employee # has been set as the Key field of the table.  If not, you will see to make change change to have the Key field be the employee ID #.

    I would also suggest trying this on a copy of your app first.


  • 10.  RE: Merging two different tables to with some similar columns

     
    Posted 05-31-2018 23:59
    Yes, 

    Listen to Coach.  Make a copy.  

    He may be able to explain this much better than I can.  I think I'm on the right track and I'm just trying to help.  :)

    Thanks!