Load if value exists in another table

[Anonymous]

In SQL I would accomplish my objective using the IN operator in conjunction with another select statement but I'm not sure how to do this in Qlikview.

I have the following two tables.

WorkforceInfo:

LOAD

     EmployeeID

     Name

     PositionTitle

     PositionType

     OtherFields

FROM

     MyQVD

WHERE

     PositionType = 'Full Time'

;

Exceptions:

LOAD

     EmployeeID

FROM

     MySpreadsheet.xlsx

;

I need to load all records from my workforce info table where the position type is full time OR where the EmployeeID exists in my Exceptions spreadsheet. What is the best way to accomplish this?

[sunny_talwar]

All those points are from when you are inactive

I think we should divide and conquer. When you are not here I can cover for you (partially) and then when you are here. I will go back to my other business

[Kushal_Chawda]

sunny macha raha tu

[sunny_talwar]

No problem at all, our trio of Stefan, Tamil and Sunny is glad to help you anytime

Best,

Sunny

[Anonymous]

You guys are awesome. I was messing around with this for an hour before I posted. Thanks for saving my afternoon!

[fbar]

Tamilarasus solution is WAY faster; I often use it for big data sets in QVD (>10 Mio Entries)