I have two tables with different date ranges and 1 date that overlaps how do I exclude that specific date?

[#1]

Here is the scenario:

1 table has the following data with date ranges and X units

Date:                   Units

Week 1                 

Week 2                       

Week 3

Week 4

Week 5

Another Table has the following date ranges and X units

Week 5

Week 6                 

Week 7                       

Week 8

Week 9

Week 10

Week 11                 

Week 12                       

Week 13

I need table 1 to exclude Week 5. Also this report will be updating each week so next week for instance table 1 will have week 1-6 and table 2 will have week 6-13 and therefore I need to exclude week 6.

Any help on this would be greatly appreciated.

Thanks

[settu_periasamy]

Maybe try this

Find the max week for your existing qvd and assign it to one variable.. like

LOAD fields from source where weekfield <=$(vmax week)-1;

Concatenate

Load fields from new source;

[shree909]

Hi ,

You can use exists function to  exclude the  Week 5

Table1:

load * inline [

Date                

Week 1                

Week 2                      

Week 3

Week 4

Week 5

Week 6

];

Table2:

Load *

where not Exists(Date );

load * inline [

Date                

Week 6                

Week 7                      

Week 8

Week 9

Week 10

Week 11                

Week 12                      

Week 13

];