Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QVD

Hi,

Please find the attached QVD. This qvd contains five weeks data(from 2013W01 to 2013W05). I need this QVD to be separated into five qvd's based on week. I don't have any date field in this qvd.

Ex:2013W01 data should be in one qvd

2013W02 data should be in another qvd..

Please help me..

2 Replies
michael_maeuser
Partner Ambassador
Partner Ambassador

see attached

Not applicable
Author

Hi

use a loop

ex :

T1:

For each Week in 1, 2, 3, 4, 5

do..

LOAD your QVD

where WeekField = $(Week)

STORE T1 into W$(Week).qvd;

drop Table T1;

next

best regards

chris