Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.)
can you please share a sample file and come up with clear requirement
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.)
Thank you for your replay Sunil, Prob Resolved.