4 Replies Latest reply on Apr 25, 2018 6:43 AM by Rachel Nelson

    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?