Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I'm looking for a way to get incremental data from BSEG.
I've tried SQL Subselect, but it seems not work at Qlik Sense.
Is there any idea?
Thanks in Advance.
Kate
Hi,
Try to do a inner join with the BKPF using the fields AEDAT and CPUDT, and get first the updated records, then createded records and finally concatenate with the qvd saved in the folder, you need to create a Key for the incremental loads and use de clausule Not Exists with the key.
regards,
Sandra