Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm trying to load data from SAP on a certain time per day and then store it in an existing QVD file. However it seems my QVD file gets overwritten instead of appending the new data. I'm using the code below, what am I doing wrong here?
Vooruitbetalingen:
Load
*,
Timestamp(now(), 'YYYY/MM/DD') as SNAP_TIMESTAMP;
;
SQL
Call "BRL_BE_PRD"."X_P_QV_VOORUITBETALINGEN";
concatenate(Vooruitbetalingen)
load
*
from $(vQvdPath)Vooruitbetalingen.qvd (qvd);
store Vooruitbetalingen into $(vQvdPath)Vooruitbetalingen.qvd;
drop table Vooruitbetalingen;
on facevalue code looks correct.
try loading just qvd and see what the result is
Thanks for your reply!
I load the QVD in a different dashboard and I do have just the set of 1 day.
Have a look at the following Help link, I believe it should help you confirm you have things setup correctly.
Regards,
Brett