Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Help me please

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.

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Help me please

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.)

3 Replies
SunilChauhan
Esteemed Contributor

Help me please

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

mov
Esteemed Contributor III

Help me please

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.)

Not applicable

Help me please

Thank you for your replay Sunil, Prob Resolved.