17 Replies Latest reply: May 11, 2015 9:03 AM by Mohammad Khatimiti RSS

    Fill empty value with mapping

      Hi,

       

      I want to fill empty values with mapping by an Excel file. The table in Qlikview looks like this:

       

      Header 1Header 2
      AYES
      BNO
      C
      D

       

      I have an Excel file with which I can substitute the empty values with YES or NO according to header 1 (in this case according to C and D). How can I do this?

       

      Thank you in advance!