Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

andreyfcdk91
New Contributor III

Re: Identify type of joining

Thanks, dear.

Re: Identify type of joining

Why is 5 included, but 1 or 2 not included in your final output?

andreyfcdk91
New Contributor III

Re: Identify type of joining

Sorry, it's my mistake:

Necessary result:

 

IdF1
13
2ed
3fd
4dfd
5fdf
7u
Highlighted

Re: Identify type of joining

May be like this:

A:

LOAD Id,

          Field1,

          Id&Field1 as Check

FROM....

B:

NoConcatenate

LOAD Id,

          Field1

FROM ...

Where not Exists(Check, Id&Field1);

DROP Table A;

andreyfcdk91
New Contributor III

Re: Identify type of joining

Perfect!

Thanks!

Community Browser