Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Arnec
Contributor III
Contributor III

Table won't concatenate

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;

Labels (2)
3 Replies
dplr-rn
Partner - Master III
Partner - Master III

on facevalue code looks correct.

try loading just qvd and see what the result is 

Arnec
Contributor III
Contributor III
Author

Thanks for your reply!

I load the QVD in a different dashboard and I do have just the set of 1 day.

Brett_Bleess
Former Employee
Former Employee

Have a look at the following Help link, I believe it should help you confirm you have things setup correctly.

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/QVD_Incremen...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.