Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
skyline01
Creator
Creator

identify rows in 1 table not in another table

I have the following 2 tables:

Table1:
Load * Inline [
ID1
1
2
3
4
5
]
;

Table2:
Load * Inline [
ID2
1
2
3
]
;

I want to create a third table that has all rows from table 1 that are not in table 2.  (ID1 and ID2 are the same attribute.  I just labeled them uniquely in case it matters.)  How can I achieve this?

1 Solution

Accepted Solutions
Vegar
MVP
MVP

Table1:
Load * Inline [
ID1
1
2
3
4
5
];

Table2:
Load * Inline [
ID2
1
2
3
]
;

Table3:
Load
ID1 as ID3
Resident Table1
WHERE
NOT EXISTS(ID2, ID1)
;
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

1 Reply
Vegar
MVP
MVP

Table1:
Load * Inline [
ID1
1
2
3
4
5
];

Table2:
Load * Inline [
ID2
1
2
3
]
;

Table3:
Load
ID1 as ID3
Resident Table1
WHERE
NOT EXISTS(ID2, ID1)
;
Plees ekskuse my Swenglish and or Norweglish spelling misstakes