Logic

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI ALL,

Please find the attachemnt of the QVW file and Excel data.

My requirement is

In Databse the recods are added newly that is insert only and they will delete the previous added recods ..

bu in qlikview i have to show all the recods by concatenating the new one with the previous one ..

for that i have created a qvd .. then fetching this QVD and then concatenating the new recods from DB and then storing it as a qvd ..

but by doing this iam still getting only the new recods ..

Say for example i have the data like below

DEPT ID Score

A 1 100

B 2 200

C 3 300

I will create the QVD for this and store it ... then will consider this QVD as a backup and then will concatenate from DB now where the previous recods are deleted

and new recods are created like below

DEPT ID Score

D 4 400

E 5 500

F 6 600

how can i acheve this ..Expertise please suggest

Thanks and regads

Re: Logic

jyothish8807 — Wed, 30 May 2018 12:39:54 GMT

Hi Try like this:

There are multiple way to achieve this, try the below mentioned easy approach:

1. Create a qvw (only for first time load) // Run this qvw only once to create your first qvd.

T1:

Load

Dept,

ID,

Store

from <>;

Store T1 into Table1.qvd;

2. Create a new qvw for Incremental load (Since DB will always have an updated data )

T2:

Load

Dept,

Store

from table1.qvd;

concatenate

load

Dept,

ID,

Store

from <file>;

store T2 into Table1.qvd;

Br,

topic Logic in QlikView

Logic

Re: Logic