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