On reading data from two tables with the same structure
For example, there are tables 1 and table 2 with the same structure in the source DB, the data will load and write to the sink DB table 3, if the connection is changed from table 1 to table 2, then data in sink DB table 3 includes both table 1 data and table 2 data. Is it correct?
The data load to the table 3 is an overwrite or incremental, or can be adjusted?
That depends on how you are dealing it within qlik script. If the data structures are same and you load the two tables one after another, by default these two tables would get concatenated and form one table in qlik. Now changing your data connection from one table to another is not very clear to me.
Writing back to third table would be an overwrite if you don't take special measures in the script. If you need incremental, you have to implement that in the script. You can also look into Merge statement and see if that fits your requirement for the same.
