store .QVD data in different folder

[geam1988]

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

[mikaelsc]

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

[vishsaggi · Accepted solution]

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;

[swuehl]

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)