4 Replies Latest reply: Sep 19, 2018 4:43 AM by Tim Poismans RSS

    Max(Month) load help

    Mahitha M

      Hi Experts,

       

      Can any one please help me on below requirement.

       

      I have a qvd load  like below. Here Month Field contains the data from Jan to Sep.

      How to load only Max(Month) data dynamically instead of hard code in where condition.

      Please help me on this.

       

      Load

      Month,

      ID,

      Salary,

      Branch

      From …

      where Month='Sep';

       

      Thanks in advance.