5 Replies Latest reply: Oct 8, 2014 8:21 AM by Tom Arne Sivertsen RSS

    Last non empty value in pivot table

      Hi All,


      . I have a requirement to replace nulls with previous not null value.  Can you  suggest a solution with which we can achieve
      the same


      Options I tried.


      1. Above
      function: One level is working. Failing with multiple nulls

      2. Peek
      function in script level. Fact is having 100M records. Outer join will not be a good solution

      Below link will give a clear idea on requirement



      Thanks in Advance