Skip to main content
Question

I am new to Quick base. I need a help on merging two tables in to a new table.

My Fist table 'Table1'
|Column1| Column2| Column3|
|T1R1D1| T1R1D2|T1R1D3|
|T1R2D1| T1R2D2|T1R2D3|

My second table 'Table2'
|Column1| Column2| Column3|
|T2R1D1| T2R1D2|T2R1D3|
|T2R2D1| T2R2D2|T2R2D3|
|T2R3D1| T2R3D2|T2R3D3|

My third table 'Table3' has same columns as 'Table1' and 'Table2'. How can I merge(or append) the 'Table1' and 'Table2', so that 'Table3' should have following data.
|Column1| Column2| Column3|
|T1R1D1| T1R1D2|T1R1D3|
|T1R2D1| T1R2D2|T1R2D3|
|T2R1D1| T2R1D2|T2R1D3|
|T2R2D1| T2R2D2|T2R2D3|
|T2R3D1| T2R3D2|T2R3D3|

    This topic has been closed for replies.

    If there isn�t duplicate data in the tables then you just need to import the data from one of the tables into the other.

    1) run a report (with all of the data) from one of the tables
    2) choose �save as spreadsheet� from the �more� menu
    3) copy the data in the spreadsheet to the clipboard
    4) go to the other table and choose �import/export� from the �more� menu
    5) choose the �import into a table from the clipboard� option
    6) make sure all of the data will be uploaded into the correct columns and finish the import
    Terms & ConditionsAccessibility statement