Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
katetsan
Creator
Creator

Extract Data From SAP BSEG

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

Labels (4)
1 Reply
Sarocame
Partner
Partner

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