3 Replies Latest reply on Dec 10, 2017 7:53 PM by Shinichiro Murakami

    Return first Not NULL value in a partition

    Rahul Tiwary

      Hi,

       

      In the below dataset I need to return the first not null value for each partition. Can somebody please help.

       

      Dataset:

         

      ItemFirstSoldName
      1NULLJack
      113Rob
      12Simon
      2NULLMat
      26Erik
      212Rob
      3NULLJack
      39Gon
      39Rob
      4NULLErik
      4NULLRob
      412Jack

      Output:

        

      ItemName
      1Rob
      2Erik
      3Gon
      4Jack

       

      Is there anyway to establish this using LOD?

       

      Thanks in advance.