Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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