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


    Harshana Etampawala



      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.