Where condition using 'IN' 'LOAD'

[boorgura]

Hi Qlikers,

As we do in SQL:

Select <f1>, <f2> from abc where <f1> IN (Select <f1> from def)

Can we do a similar execution using the LOAD in Qlikview.

LOAD <f1>, <f2> resident abc where <f1> IN (LOAD <f1> resident def)

Did not research a lot. Thought first I will ask you guys.

[Oleg_Troyansky]

Rocky,

unfortunately, "IN" functionality is not implemented in QlikView. You can use somewhat similar exists(), only keep in mind that the comparizon is performed at the field level, as opposed to a table level. If you have to ensure that you are comparing to existing values of a field in a specific table, make the field unique to tha table (in other words, if you compare to a key field, create another copy of the same field just in the desired table, and compare to the copied field instead.

[#3]

I use match instead

match( s, expr1 [ , expr2, ...exprN ] )

Compares the string s to a list of strings or string expressions. The
result of the comparison is an integer indicating which of the comparison
strings/expressions matched. If no match is found, 0 is
returned. The match function performs a case sensitive comparison.
Examples:
match( M , 'Jan' , 'Feb' , 'Mar' )
where M is 'Feb' returns 2
match( M , 'Jan' , 'Feb' , 'Mar' )
where M is 'Apr' or 'jan' returns 0

[boorgura]

I would do the same thing if it were a limited standard set of values to compare with.

But that is all the data for a given date.

So, I would assume this not to be solution for it.