Forum Discussion

ChinmayaMishra's avatar
ChinmayaMishra
Qrew Member
8 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...
App builders
Ask about Quickbase functionality
Formulas and functions
ForrestParker's avatar
ForrestParker
Qrew Cadet
8 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.