Discussion Board for collaboration related to QlikView App Development.
I am new to Qlikview Please Help me
The above is Source.I want to display Which names are not in Tab1 means the below is target
Iam trying with the below Script:
Name as Name1
Load * resident A where Name<>Name1
drop table A;
But, it is showing All records.
Go to Solution.
A:NOCONCATENATELOAD Name as Name 1 RESIDENT Tab1;
B:NOCONCATENATELOAD Name RESIDENT Tab2WHERE 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.)
can you please share a sample file and come up with clear requirement
Thank you for your replay Sunil, Prob Resolved.