topic Please help on this Requirement in QlikView

Please help on this Requirement

Mon, 08 Feb 2016 16:23:20 GMT

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 — Mon, 08 Feb 2016 16:29:42 GMT

Can you share a sample with expected output?

oknotsen — Mon, 08 Feb 2016 16:30:12 GMT

Consider using the KEEP function.

Mon, 08 Feb 2016 17:05:18 GMT

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

sathishkumar_go — Mon, 08 Feb 2016 17:24:14 GMT

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

Mon, 08 Feb 2016 17:27:39 GMT

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 — Mon, 08 Feb 2016 18:51:20 GMT

What makes "keep" not a condition?

Anonymous — Mon, 08 Feb 2016 18:54:01 GMT

Would Where Exists() help ?