Merging/Joining results of 2 queries

[Anonymous]

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

[Anonymous · Accepted solution]

Various options spring to mind.

• Join or Concatenate the tables then do your transformations
• Use some Mapping Loads and ApplyMaps

The details will depend on your table structures and required calculations.

You may well have to load from Resident.

Here are some links to potentially useful bits in the online manual:

• https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/load-data-from-previously-loa...
• https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/combine-tables-join-keep.htm
• https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/LoadData/concatenate-tables.htm