3 Replies Latest reply: Jan 4, 2013 6:18 AM by Evelien Morel RSS

    Load Resident - where clause

    Evelien Morel

      Hi All,

       

      I'm having trouble and I don't see what i'm doing wrong.

      Could someone shed some light?

       

      I have a facts table with data from 2011, 2012 and 2013.

      Since the new year has started and I only want to see data from 2 years, I thought to do a resident load to eliminate the data from 2011.

       

      Here you see the piece of code.

       

      // ================================ Data beperken op basis van jaar ============================================

      INVDETyear:

      LOAD

      *

       

      Resident INVDET

      where Year > 2011;

       

      drop Table INVDET;

       

       

       

      If I execute this code, my facts table dissappears and I'm left with no data.

      I've tried a lot of modifications on this code, nothing seems to work.

       

      Am I missing something fundamental here?

       

      Thanks for your help.