1 Reply Latest reply: May 4, 2017 1:18 AM by Rahul Pawar RSS

    Outer Joining to a table (after many outer joins) ???

    Casey Johnson

      Trying to figure out how to add fields to an existing table that has many OUTER JOINS and utilizing info from the initial LOAD and info from the OUTER JOINS to sync up the new information. I've gotten pretty far in Qlik Sense just using OUTER JOINS to create my QVDs, but there's probably a cleaner way to do it?

       

      Example:

      [Table A]:

      LOAD

      a,

      b,c,d,e

      SELECT ...

      FROM ....

       

      OUTER JOIN (Table A)

      LOAD

      a,

      f,g,h

      SELECT ...

      FROM ....

       

      *** QUESTION IS: How do I grab "a" from first LOAD and "f" from second LOAD to OUTER JOIN some new data to this table? Or is there a better way to do this ? ****

        • Re: Outer Joining to a table (after many outer joins) ???
          Rahul Pawar

          Hello Casey,

           

          Trust that you are doing good!

           

          As a workaround, you can make use of Mapping Load and ApplyMap functionality to get the "f" from second LOAD if first LOAD & second LOAD is related to each other (To do so change the LOAD order i.e. first LOAD becomes second and vice-versa). Post that, in first LOAD create a composite Key (a & '|' & f AS Key) to utilize it in further joins.

           

          Hope this will be helpful.

           

          Regards!

          Rahul