4 Replies Latest reply: Aug 22, 2014 2:26 PM by Kilgore Watts RSS

    Table creation in script question

    Matt Maino

      I have created a table in my data model called AllData. I would like to create a new table (called PreviousData) in the same data model that loads all the fields from AllData, but only for a specific date (which is a field in AllData). I can't seem to get the syntax right. Can somebody help me with this?

       

      I'd assume it looks something like what I have below but I'm not sure where to put the where clause.

       

      PreviousData:

      Load *,

       

      Resident AllData;

      where PROD_DT = '07/31/2014';