Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
see attached
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