Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can't you club two fields into one date field?
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
Can i see sample sketch model of yours how it is connected?
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
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