topic Help me please in QlikView

Help me please

Mon, 14 Nov 2011 10:53:40 GMT

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:

Tab2:

Left join

Tab1

Name,

Name as Name1

Load * resident A where Name<>Name1

drop table A;

But, it is showing All records.

SunilChauhan — Mon, 14 Nov 2011 11:23:07 GMT

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

Anonymous — Mon, 14 Nov 2011 11:32:05 GMT

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

Tue, 15 Nov 2011 04:54:42 GMT

Thank you for your replay Sunil, Prob Resolved.