2 Replies Latest reply: Apr 1, 2014 5:32 AM by Tresesco B RSS

    Distinct table isn't distinct after preceding load

    Kristof Jacobs

      Hi

       

      I did something really simple

       

      LOAD  Distinct MonthStart(Date) as month

      Resident Orders;

       

      I have now a distinct table with months.

      But I wanted to add the previous month. So I did the next thing ...

       

      LOAD  month
      ,
      AddMonths(month,-1) as [month-1];
      LOAD  Distinct MonthStart(Date) as month
      Resident Orders;

       

      And now my table isn't distinct anymore. It's like QV ignores the first 'Distinct'.

      When I add a distinct in the preceding load the table is distinct again

       

      My problem is that there is an impact on efficiency.

      Did I do something wrong?

       

      thanks in advance