6 Replies Latest reply on Oct 19, 2018 2:03 AM by Mahfooj Khan

    How to covert NULL values into the values of current or previous row within dimension

    Nivedan Kesavan
      Nameclasscountry
      ahighIND
      NULL
      blowNULL
      USA
      NULL
      chighNULL

       

      I connected to oracle database and got a view , where it looks like above in Tableau.

      I need to exclude NULL for Name a and have it as single row with only IND .

      I need to exclude 2 NULL's for Name b and have it as single row with only USA.

      I need to include NULL as like it shown for Name c.

       

      The data should look like below:

       

      Nameclasscountry
      ahighIND
      blowUSA
      chighNULL

       

      Please help on the same.