3 Replies Latest reply: Sep 5, 2018 7:13 PM by Samuel Washburne RSS

    Applymap for Null values after Qlik join

    Samuel Washburne

      stalwar1 johnw cri

       

      Hello to the above and anyone that can help!

       

      I am trying to map null orphan values to a default value of 0 after an outer join has occurred. Is this possible?

       

      Here is the code:

       

      [Tracker]:

      LOAD

          "MIA CASE SEQ" as [MIA CASE SEQ-MIA_CASE_SEQ],

          MT,

          Y,

          AU,

        

      FROM mysource

       

      [Other table]:

      Load

      "MIA_CASE_SEQ" as [MIA CASE SEQ-MIA_CASE_SEQ],

      FIELD1

      FIELD2

      FIELD3

      From qvd.source

      **Now, how do I go about applying a map to this outerjoined table?  I need to make sure that all the in all the instances that there was not a join on the [MIA CASE SEQ-MIA_CASE_SEQ] that the corresponding orphan nulls for AU, MT, and Y = 0. **


      Any thoughts/comments would be much appreciated.


      Thanks,

      Ben