What are the potential pitfalls of merging many tables into a single table? What are the best practices and things to look out for when merging many tables into a single table?
Just to confirm merging (adding columns) or appending (adding rows)?
Hi @Melissa! Merging not appending.
Thanks. When performing multiple merges, I think the two most common issues are:
- unwanted/unintended duplication of records and
- performance issues (making sure your table has a primary key can improve performance)
If you have an option to outsource these merges to SQL or whatever you have in the backend, I would start there. Some articles you might like to review:
I hope this is helpful.
2 Likes