Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Qlik Experts ,
i'm using two view table in my qlik application , now i doing incrimental load in my application and i wants to give condision to update only same day data , i mean i dont want to fatch old data from erp which i has already in my qvd . i have attached both table in excel sheet so plz revert this will give me idea how to use incimenatal load
table name-
1-xxm3m_receipts_data_vw(transection date-RECEIPT_DATE
2-xxm3m_qlkvw_project(transection date-PROJ_DUE_DATE)
so you can go with where condition in fetch query ex use today's date . then use exists/not exists in your incremental load .
PS : assuming you already written code for incremental load and facing issue .
Thanks
BKC