topic Table won't concatenate in QlikView

Table won't concatenate

Arnec — Sat, 16 Nov 2024 01:17:21 GMT

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;

Re: Table won't concatenate

dplr-rn — Thu, 13 Feb 2020 14:23:40 GMT

on facevalue code looks correct.

try loading just qvd and see what the result is

Re: Table won't concatenate

Arnec — Thu, 13 Feb 2020 15:58:42 GMT

Thanks for your reply!

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

Re: Table won't concatenate

Brett_Bleess — Wed, 11 Mar 2020 15:11:14 GMT

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_Incremental.htm

Regards,
Brett