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

    Merging/Joining results of 2 queries



      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!