4 Replies Latest reply on Nov 14, 2017 8:27 AM by gp75062

    replacing null value in row with non non value from different row but same column

    gp75062

      Can this be done?

       

      I have data as following

        

      Regionmodelnamecoderevenueexpenses
      Northeastxabcxyz1000
      Northeastxabcnull0100
      southwestydefxyz1110
      southwestydefnull010

       

      but i need to convert all null codes to non null codes from different row but same column.

       

        

      Regionmodelnamecoderevenueexpenses
      Northeastxabcxyz1000
      Northeastxabcxyz0100
      southwestydefxyz1110
      southwestydefxyz0

      10

       

       

      then aggregate them and get final result as following

       

        

      Regionmodelnamecoderevenueexpenses
      Northeastxabcxyz100100
      southwestydefxyz11110

       

       

      Thanks