Discussions

Expand all | Collapse all

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

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

    Posted 08-22-2018 13:59
    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|



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

    Posted 08-23-2018 00:55
    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


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

    Posted 01-25-2019 15:40
    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.