Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ioannagr
Creator III
Creator III

how to implement incremental load to a table with UNION in sql part

Hello,

my initial qvd included a UNION of two tables in the SQL part.

So for incremental load on id, i suppose I must break the tables in two and implement incremental loads  on id for each one and then concatenate  the tables I guess but that seems not right to me.

Or should I implement it the casual way by adding where clause after union like  "where tab1.id> '$(Maxid)' and tab2.id>$(Maxid)'  ?

0 Replies