1 Reply Latest reply: Nov 18, 2016 3:41 AM by Bill Markham RSS

    Merging/Joining results of 2 queries

    Kamil Stachowicz

      Hello

       

      My case is as follows:

       

      I got two queries which run on different connection (query1: LIB CONNECT TO 'DB1' and query2: LIB CONNECT TO 'DB2')

      I got one field common within both queries.

       

      Now i just load the data and let the Qlik engine to do association and then I do calculations but now I would like to merge both queries (assume with LOAD statement) into one set so I can do some of the calculations while loading the data.

       

      Could you assist me how to do that?

       

      Thanks in advance!
      Kamil