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

[rwunderlich]

Load table two first:

Data:

LOAD Week, ...FROM...;

Then load table one:

LOAD Week, ...FROM...

WHERE NOT Exists(Week);

The where not exists() clause will prevent the week form loading again.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com