Help me please

[#1]

I am new to Qlikview Please Help me

Tab1

Name

Sankar

Tab2

Name

Sankar

Sunil

The above is Source.I want to display Which names are not in Tab1 means the below is target

Tab3

Name

Sunil

Iam trying with the below Script:

A:

Tab2:

Left join

Tab1

Name,

Name as Name1

B:

Load * resident A where Name<>Name1

drop table A;

But, it is showing All records.

[SunilChauhan]

can you please share a sample file and come up with clear requirement

[Anonymous · Accepted solution]

A:
NOCONCATENATE
LOAD Name as Name 1 RESIDENT Tab1;

B:
NOCONCATENATE
LOAD Name RESIDENT Tab2
WHERE not exists(Name1, Name);

DROP TABLE A;

(I'm using NOCONCATENATE here to prevent auto-concatenation to Tab1 and Tab2, which you'll probbaly have to drop as well.)

[#4]

Thank you for your replay Sunil, Prob Resolved.