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

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
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|

Photo of Chinmaya Mishra

Chinmaya Mishra

  • 70 Points

Posted 3 months ago

  • 0
  • 1
Photo of Forrest Parker

Forrest Parker

  • 598 Points 500 badge 2x thumb
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