topic Re: How to exclude data in QlikView

How to exclude data

Fri, 20 Nov 2020 18:02:30 GMT

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 — Wed, 25 Jul 2012 20:47:47 GMT

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

Thu, 26 Jul 2012 14:49:19 GMT

Thank you! It worked!