Please help on this Requirement

[#1]

Hi

i have requirement some thing like

Table 1 contain Dept id 101,102,103,104,105 and other fielsd

Table 2 Contains Emp id 101,102,103

my requirement is i need to get common fields from both the tables but should not use innerjoin

[sunny_talwar]

Can you share a sample with expected output?

[oknotsen]

Consider using the KEEP function.

http://help.qlik.com/sense/2.1/en-US/online/#../Subsystems/Hub/Content/Scripting/ScriptPrefixes/Keep...

[#4]

This Requirement has to get with only conditions not with keep and joins 

[sathishkumar_go]

Dept id and Emp Id have 2 different fields and having same values.

Common fields based on the field name or value?

Please explain ur requirement briefly?

-Sathish

[#6]

here tables are associated with other field 

i have requirement some thing like

Table 1 contain Dept id 101,102,103,104,105 and other fields

Table 2 Contains Emp id 101,102,103

i need to get the data Emp id Dept id =Emp id

[oknotsen]

What makes "keep" not a condition?

[Anonymous]

Would Where Exists() help ?