Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;