9 Replies Latest reply: Sep 6, 2011 6:41 AM by Sam Vile RSS

    Scripting Issue - please help

      Hello fellow Qlikviewans,

       

      I have the following syntax which takes data from my FUM QVD every month. Now instead of the new data overwriting what I already have in the below table, I want the new data to be appended to the bottom instead...can someone PLEASE let me know how to script this as I'm pulling my hair out?!!

       

      FUM:

      LOAD [Bid Price],

           DOB,

           [Fund Name],

           [Fund No],

           [Fund Value],

           [Policy Number],

           [Scheme Name],

           [Scheme Number],

           Sex,

           Units,

           [Policy Status],

           [Valuation Date]

      FROM

      [J:\CBS\Management Information\QlikView\Development\Data sources\QVDs\NewQVDs\FUM.qvd]

      (qvd)