Help

Merge Tables

Solved
Jump to Solution
2109 5
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Juan_Ferrari
4 - Data Explorer
4 - Data Explorer

Hi, I use to have 1 data base for sales, delivered or not, but for some reason I thought It would be faster for searches and stuff to leave the delivered sales in anothe identical table. So I duplicated the table and erased the records that were "to deliver"in the delivered and "delivered" in the non delivered.

It didn't worked as planed and now Im trying to go back, but I can't find the way.

I just need to merge them back into one. Is there any simple way?

 

Thanks
Juan

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

It is easier to copy and paste records if you create a plain View with no filters and no sorting set up. You can add records without overwriting them by pasting them into the last row.

See Solution in Thread

5 Replies 5
Sistema_Aotearo
9 - Sun
9 - Sun

You should be able to copy and paste. With the expand table option might help too.

You can also export the new table to a csv and then re-import to the original?


Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/
Sho
11 - Venus
11 - Venus

It is easier to copy and paste records if you create a plain View with no filters and no sorting set up. You can add records without overwriting them by pasting them into the last row.

Thanks for the reply.

 

It has pictures and pdfs in it, copy and paste is not working.

CSV file is not working too.

Any other Ideas?

 

Fixed it, it was the orther of fields was the problem.

Thanks

MrsMaguire
4 - Data Explorer
4 - Data Explorer

Thanks so much for this - didn't realise the importance of turning off filter / sort for merging.