topic Re: store .QVD data in different folder in QlikView

store .QVD data in different folder

geam1988 — Thu, 27 Sep 2018 18:43:48 GMT

Hallo,

Store VBAP into D:\VBAP.qvd; // path 1 (want all werks)

Store VBAP into D:\test\VBAP.qvd; // path 2 where werks = '3000' (want only werks 3000)

we load the data from sap. we have 2 different path. in path 1 we load all data but in path 2 we want to load the data only for werks 3000. if i use where werks = '3000' ; than it load the data only for werks 3000 in both path but i want to have all werks in path 1.

what should i do ?

best regards

Kazi

Re: store .QVD data in different folder

mikaelsc — Thu, 27 Sep 2018 19:21:03 GMT

create 2 different tables (with a resident load?) and store them in your 2 locations...

Re: store .QVD data in different folder

vishsaggi — Thu, 27 Sep 2018 19:27:34 GMT

May be Try like:

Store VBAP into D:\VBAP.qvd(qvd); // path 1 (want all werks)

Drop Table VBAP;

VBAP:

LOAD *

FROM D:\VBAP.qvd(qvd)

WHERE werks = 3000;

Store VBAP into D:\test\VBAP.qvd(qvd);

Drop Table VBAP;

OR other way is as Mikael suggested using Resident Load like below

Store VBAP into D:\VBAP.qvd(qvd); // path 1 (want all werks)

NOCONCATENATE

VBAPTest:

LOAD *

RESIDENT VBAP

WHERE werks = 3000;

Store VBAPTest into D:\test\VBAP.qvd(qvd);

Drop Table VBAP, VBAPTest;

Re: store .QVD data in different folder

swuehl — Thu, 27 Sep 2018 19:58:07 GMT

Maybe like

Store VBAP into D:\VBAP.qvd; // path 1 (want all werks)

INNER JOIN (VBAP)

LOAD 3000 as werks

autogenerate 1;

Store VBAP into D:\test\VBAP.qvd; // path 2 where werks = '3000' (want only werks 3000)