Solved: Re: How to exclude data - Qlik Community

Report Inappropriate Content · ‎2012-07-25

Hello I'm new in Qlikview and I don't know how to solve this problem on my script. I have two tables:

Material	Vmatriz
7	NG0130

How can I get all the data from table one, plus the data from the second table that is not on table 1?

In this case my result should be

Thank you for your help

MayilVahanan · ‎2012-07-25

HI,

You can use not exists() in your script like this

Load Employee, ID, Salary from Employees.csv;

Load FirstName& ' ' &LastName as Employee, Comment from Citizens.csv where not exists (Employee, FirstName& ' ' &LastName);

Hope it hels

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

MayilVahanan · ‎2012-07-25

HI,

You can use not exists() in your script like this

Load Employee, ID, Salary from Employees.csv;

Load FirstName& ' ' &LastName as Employee, Comment from Citizens.csv where not exists (Employee, FirstName& ' ' &LastName);

Hope it hels

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Report Inappropriate Content · ‎2012-07-26

Thank you! It worked!