Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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
Highlighted
Partner
Partner

on facevalue code looks correct.

try loading just qvd and see what the result is 

Highlighted
Contributor II
Contributor II

Thanks for your reply!

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

Highlighted
Digital Support
Digital Support

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.