Split data

[#1]

Hello,

T:
LOAD * INLINE [
F1, F2, F3
1, a, 1
1, a, 2
1, a, 3
1, a, 4
1, a, 5
1, a, 6
1, a, 7
2, a, 8
2, b, 9
2, b, 10
2, b, 11
2, b, 12
2, b, 13
];

T2:
LOAD F1 as F,F2 as F_1,F3 as F_2
Resident T
Where F1 =1 or F2 ='a'
;

QUALIFY *;
T3:
LOAD F1 as F,F2 as F_1,F3 as F_2
Resident T
Where F1 =2 or F2 ='b'
;

When i load this data the third table it should not get the data of 2,a,8. B'coz it is already retrived in T2 table. How can i control this.

Wt is exactly want is i'm partitioning the qvd file for every 1wk.But based to F2 column started time. If the data of F2 is started in first wk and it is continue in second wk then the second wk data also  retrive in first wk data instead of 2nd wk.  When i'm trying to retrive in second table it should not retrive the data already loaded in first table.

[#2]

No Worries jacq, glad to have been some help.