4 Replies Latest reply: May 14, 2014 5:49 PM by Ajay Krishnan Prabhakaran RSS

    FULL JOIN equivalent with load?

      Hi, all.

       

      I have two tables that appear as follows, counting attempted/successful events in my application:

       

      Attempt Table

      keyvaluecount
      1Authentication2
      1Account Lookup1
      1Bill Pay1

       

      Success Table

      keyvaluecount
      1Authentication1
      1Account Lookup1

       

      I am trying to load this data so it appears as follows:

      keyeventattemptedsuccessfuldelta
      1Authentication21-1
      1Account Lookup110
      1Bill Pay100

       

      In SQL, I'd do this with a FULL JOIN on key and value from both tables, and converting null counts to to zeroes.

       

      How do I accomplish the same using QV's LOAD mechanism?

       

      Thanks!

      Eric