topic Re: exists in QlikView

exists

Anonymous — Thu, 09 Feb 2017 06:31:43 GMT

I have two different code column

Code 1 and code 2 , both codes coming from two different tables. Code2 has more data than code1. How to find what are the codes extra in code2 that is not available in Code1

Re: exists

tresB — Thu, 09 Feb 2017 06:43:57 GMT

May be like:

Tab1:

Load * Inline [

Code1

];

Tab2:

Load * Inline [

Code2

111

];

Load

Code2 as OnlyInTab2

Resident Tab2 where not Exists(Code1,Code2);

Re: exists

sdmech81 — Thu, 09 Feb 2017 07:39:34 GMT

Hi ,

Plss find the attached QVW file.

Which works in your case.but do use flags if data model is huge.Hope this helps

Thanks

Re: exists

sdmech81 — Thu, 09 Feb 2017 07:41:01 GMT

If PE limit crossed,below is the script copy paste and run:

sac:

load * Inline [

Code1,sirname
1,sac
2,dag

];

sac2:

load * Inline [

Code2,name
1,sac
2,dag
3,mac

] where not Exists (Code1,Code2);

Re: exists

Chanty4u — Thu, 09 Feb 2017 08:00:35 GMT

From Help File:

Employees:

LOAD * inline [

Employee|ID|Salary

Bill|001|20000

John|002|30000

Steve|003|35000

] (delimiter is '|');

Citizens:

Load * inline [

Name|Address

Bill|New York

Mary|London

Steve|Chicago

Lucy|Paris

John|Miami

] (delimiter is '|');

EmployeeAddresses:

Load Name as Employee, Address Resident Citizens where not Exists (Employee, Name);

Drop Tables Employees, Citizens;

OutPut:

Employee

	Address
Mary	London
Lucy	Paris