2 Replies Latest reply: Feb 5, 2016 3:31 PM by Tim Lathrop RSS

    Resident load taking too long

    Tim Lathrop

      Can someone help me change a resident load to a traditional load from the original QVD files?  This is my resident load script.

      Concatenate

      EOM:

      LOAD

                Date(CurveDate,'MM/DD/YYYY') as 'CurveDate',

           Num(ProfitLoss,'$#,##0.00;($#,##0.00)') as 'PnL',

           Date(Monthend(RangeBegDate), 'MM/DD/YYYY') as 'LastDayofMonth',

           Source,

           DealType,

           ProfitCenter,

           Portfolio,

           RiskType

       

      resident PnL

      where

      Date#(MonthEnd(CurveDate), 'MM/DD/YYYY') =Date#(CurveDate,'MM/DD/YYYY')

      and

      Date#(MonthEnd(CurveDate), 'MM/DD/YYYY')=Date#(Monthend(RangeBegDate), 'MM/DD/YYYY')

      I'm trying to create a end of month total.  When i changed the source of data from resident to qvd I got nothing???