Forum Discussion

ChinmayaMishra's avatar
ChinmayaMishra
Qrew Member
7 years ago

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|

App builders
Ask about Quickbase functionality
Formulas and functions
  • ForrestParker's avatar
    ForrestParker
    Qrew Cadet
    7 years ago
    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
    • JayaKrishna's avatar
      JayaKrishna
      Qrew Trainee
      7 years ago
      Hi,
        
       I want to merge all 5 tables data into 1 new table, And all these 5 tables 
      contain the same field names, And also there is no relationship between these 5 tables.
      whenever I perform Add/Edit/Delete Action on each individual table the data should be updated on this newly created table.