Insert and Update records from two Tables

[QVUser1]

Hi,

I am new to new Qlik sense .I have two different tables Table1 & Table 2 Where these two tables  are to be created into single Qvd and these records are to appended on daily basis coming from DB and also update the records coming from flow like highlighted in blue color.

[Prashant_Naik20]

Hi,

If i am getting this right below suggestion should work.

You can try to concate both the table into one and store it in qvd. before storing the table flag each table as tbl1 as store_flag and tbl2 as store_flag.

So when you want to load this table differently you can put where condition on flags.

And to update the records you can use where exists function - https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/ 

Hope it helps.

Regards,

Prashant