topic No concatenate + not exists function's output mismatch in QlikView

No concatenate + not exists function's output mismatch

namratam3 — Wed, 25 Nov 2020 16:16:04 GMT

I am new to qlikview.Could someone please help in understanding the concept of (no concatenate + not exists function) as in above output I m able to see that the count of name'Naman' is not correct but when I remove no concatenate word from script count comes corrects. How this is happening.

Could someone please explain why id2 '10' and field name2 'naman' count is coming 1 instead of 2 by using exists and no concatenate statement in between two table loads.

Message was edited by: namrata maheshwari

Re: No concatenate + not exists function's output mismatch

Lisa_P — Wed, 27 Jun 2018 00:52:40 GMT

Hi Namrata,

Let's take it one step at a time.

temp1 table loads and inserts N/A into the Id1 for rahul, all others are loaded as per data source.

temp2 table is limited by where exists and will only load the Id values in Id2 that match those loaded in Id1

temp3 table will not concatenate with temp2 which causes a synthetic key to provide the link between these tables.

If you take away the NoConcatentate, but leave the not exists, this will combine temp2 and temp3, appending any new values

Hope this helps.

Lisa