1 Reply Latest reply: Oct 2, 2012 8:10 AM by Gysbert Wassenaar RSS

    load fragments of data

    lin ye

      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