6 Replies Latest reply on Jan 9, 2019 7:59 PM by Joshua Milligan

    Tableau Prep: Fill in missing/null values with previous value

    Rachel Nelson

      I can't seem to figure out how to use tableau prep to fill missing/null values with previous value. Example below:

       

      Column1

      Qty

      Apples

      2

       

      4

       

      6

      Oranges

      8

       

      9

       

      2

      Banana

      4

       

      To

       

      Column1

      Qty

      Apples

      2

      Apples

      4

      Apples

      6

      Oranges

      8

      Oranges

      9

      Oranges

      2

      Banana

      4

       

      I am looking to find how to fill in a blank or null field with the field above it.

       

       

      Example Calculations

      IF ISNULL([Column1]) OR ([Column1]="") THEN [Row-1:Column1]

      ELSE [Column1] ENDIF

       

      or

       

      Set col" column1 value" fill(ifmissing($col,NULL())) order:SourceRowNumber()

       

      Any ideas?