9 Replies Latest reply: Feb 18, 2014 3:17 PM by Srikanth P RSS

    Using a Variable when loading from QVD

      Hi,

       

      I am trying to load from a QVD only the records where the fiscal week is equal to max fiscal week.

       

      I was wondering if someone would be able to point out the error in what I am doing:

       

      Table1:

      Load

      Max(Fiscal_Wk) as MaxFW

      Resident Table;

       

      vWeek=  MaxFW;

       

      Table2:

      Load *

      Resident Table where Fiscal_Wk = $(vWeek); 

       

      //Store

      Store Table2 into (Folder Location);

       

      Drop Tables Table, Table1, Table2;

       

       

      Thanks for your help!

       

      Archie