I have two tables with identical columns structures. The reason why they have to remain as separate tables is because they are querys from 2 separate SQL databases. Is there a way to make appsheet ready 2 separate tables as 1?
Unfortunately, there is no UNION operation function within Appsheet.
You probably need to UNION the two tables on SQL side and make VIEW. Then you connect that view from Appsheet, but the chance is that table is just read-only, but also possibly you could add, edit and delete.