Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

kamil_stachowic
New Contributor

Merging/Joining results of 2 queries

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

Tags (1)
1 Solution

Accepted Solutions

Re: Merging/Joining results of 2 queries

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:

1 Reply

Re: Merging/Joining results of 2 queries

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:

Community Browser