Incremental Load

[KundanJyothsna]

Hi Everyone,

I'm new to qliksense. I have a situation where i need to do Incremental Load  for current financial year ofnSAP MSEG Table based on 2 fields , i.e. CPUDT_MKPF(date field) & CPUTM_MKPF(time field). These 2 fields are last modified date and time fields .can anyone help me on this. A code snippet for this will be a great help in understanding.

Thanks in Advance.

Srinivas Kundan

[Anil_Babu_Samineni]

Can't you club two fields into one date field?

[KundanJyothsna]

Hi Anil,

Instead of clubbing , i took last modification date and time values in two separate variables.

Then I applied these variables  to sap generated SQL statements where clause

Like Where CPUDT _KMPF >= $(vlastmoddate) and CPUDT _KMPF >= $(vlastmodtime) ; and Checked by debugging with 1000 records and I'm able to.see lastmodificate date and time values. But when I go with normal.load, I'm getting error after loading around 1000000  records and some times I'm unable to store the table in qvd.

Can you help me on this.

Thanks,

Jyothsna Kundan

[Anil_Babu_Samineni]

Can i see sample sketch model of yours how it is connected?

[Ksrinivasan]

hi,

you can change DDate to CPUDT_MKPF,

my dummy data,

my script:

DAret:
LOAD
Product,
price,
DDate
FROM [lib://TEST/SSSS1.qvd]
(ooxml, embedded labels, table is [data format])
where "DDate">= ('02-12-2020') and "DDate"<= ('12-12-2020');

result:

you can fix from above example.

ksrinivasan

[Ksrinivasan]

hi,

fiscal year means: 01-04-2020 to 31-03-2021,

you can use from date and to date want you want in where statement in above script

where "DDate">= ('02-12-2020') and "DDate"<= ('12-12-2020');

ksrinivasan