Hi,
Every week, I get a new set of data. It includes 2 weeks worth of data on orders. Since there are 1 week of overlapping data between data set 2 and 3. How can i chop up the data, so I won't get duplicates
ie: 3 sets of data come in on a weekly basis.
(initial batch) date set 1: 9/1-9/7
date set 2: 9/1-9/7, 9/8-9/14,
date set 3: 9/8-9/14, 9/15-9/21
In the end, I want to have:
(initial batch) date set 1: 9/1-9/7
date set 2: 9/8-9/14
date set 3: 9/15-9/21
Right now I have something look like this:
sql select * from ordertbl where dataset >= '20120901' and order_date<=dataset_date and order_date>=dateset_date-7;
but it's pulling data like this:
(initial batch) date set 1: 9/1-9/7
date set 2: 9/1-9/7, 9/8-9/14,
date set 3: 9/8-9/14, 9/15-9/21
how do I get the script to recognize that it's different sets of data I am refering to? do I do a loop? very new to qlikview. please help
