2 Replies Latest reply: Jul 8, 2015 9:44 PM by Harshana Etampawala RSS

    FILLING NULL VALUES

    Harshana Etampawala

      Hi

       

      I have an issue with filling null values in the table.

       

      Please find attached sample document with a QVD  file for information. As you can see there are some null values against date and divisions.

       

      I want to put the previous value (for null value fields)against the division until the next available value in the table. The reason is I need to record a value every single day from the start date to finish date for every single location. If there is no values against a division, I want to pick up the previous value against the division

       

      Hope you will understand what I try to achieve.

       

       

      Can you please advice.

       

      Regards

       

      Harsh