How to translate IN SQL STATMENT

[#1]

I need to check different values from different tables. One is from a sql query another one is from an excel.

I would like to do something like that:

SELECT CarTypeId FROM CarType
WHERE (CarTypeId NOT IN
(SELECT DISTINCT CarTypeId FROM Cars)
)

But from the qlikview script ?

Is it feasable?

Thanks in advance

[jagannalla · Accepted solution]

Hello,

First load the field from excel sheet. Qv has Exists function which allows to check with loaded field data.Use that for sql data load viceversa..

Temp:

Load CarTypeId From ExcelData;

Main:

Load CarTypeId, 1 as CountValue

From SqlData

Where Not Exists(CarTypeId);

Drop Table Temp;