7 Replies Latest reply: Feb 6, 2015 11:01 AM by Sunny Talwar RSS

    Matching via null value

    Matt Maino

      Hi everyone,

       

      I am importing some data into my qlikview document from a database and I am also importing an excel sheet to associate the database info to another field. The table created from the database joins with the excel table via 2 fields - I'll call them field_1 and field_2. All rows in my database table contain a field_1 value, but only some of them contain a field_2 value. For those rows that do contain a field_2 value it is necessary that I join to the excel table via both fields. For the rows that do not contain a field_2 value my joining isn't working even though there is a null in the database table and a null in the excel table for field_2. Is there something that I am not doing right?

       

      field_1field_2additional_field
      12abcd
      13efgh
      2ijkl
      3mnop
      field_1field_2
      12
      13
      2
      3

       

      The table on the top is what my excel table looks like, and the one on the bottom represents the matching fields in the database table.

       

      Thanks.