Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Various options spring to mind.
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:
Various options spring to mind.
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: