Discussion board where members can get started with Qlik Sense.
Hi Qlik Experts!
I have a question about load datas from difference sources.
Let's explain with an example:
first, I have this table from DataBase 1:
The result is:
Now, I should do the same thing with DataBase2:
I decide to use both the script in the same time (and I need one table), so the result is clearly this:
Now the question: could I do a " distinct" of the last table (and how)? In other words, could I reach (and how) this result?
Thanks a lot for your time!
Go to Solution.
you could look into the Exists function: The exists issue
(that article mentions the drawback with the Exists function - but also gives a usage example)
Otherwise, you could:
Any reason you cant do the join in the database? Like:
FROM DataBase1 D1
LEFT JOIN Database2 D2
On D1.Person = D2.Person;
(assuming by database you mean a database table)
Try this, :
WHERE not exists(Person);
I'm sorry, but I cannot do this: I've not been clear about this (my fault).
Thanks, these are great topics.