Lookup with Multiple Criteria

[samuel_brierley]

Hi guys,

is it possible to have a lookup in the script with multiple criteria and if so can someone explain the Syntax?

i am trying to lookup a value from a different table in the script e,g

Table1

,,,,

Table2

[1],[2][3]

Table 3

[1]

lookup( ,

where 2 > and 2 < and [3] > and [3] < ,

Table1)

[swuehl]

If the amount of records won't blow your system, you can do something like this:

TMP:

LOAD ,,,, RESIDENT Table1;

JOIN (TMP)

LOAD [1],[2],[3] RESIDENT Table2;

RESULT:

LOAD [1], as [Match]

RESIDENT TMP

WHERE [2] > AND  [2] < AND [3] > AND [3] < ;

[Anonymous]

you might get some idea from following threads:

lookup function

Lookup function

QlikView Expressor: Using the Lookup Functions