Refering to a field in a table, while "Left Joining" a separte table

[#1]

I am left joining table 2 to table 1 . I only want to join the data from table 2 if a value in a specific column in table 1 equals 3 separate values. The where statement I am using is below, with the field from table 1 underlined . Is there a way to refer to the field in table 1 while left joining table 2?

Load Table 2

From Table 2 source

Where CreateDate > '$(startdate)' and CreateDate < '$(enddate)'
and VetTotalPrice > 0 and ItemStatus <> 'Cancelled'
and CurrentStatus=('Shipped' or 'Partial Ship' or 'Wait to Ship')

;

Thanks so much!

[Oleg_Troyansky · Accepted solution]

No, you can't access data from another table while loading a table, at least not directly...

I'd recommend creating a map that translates your "common key" field with the required data field (like CurrentStatus) and to use function "ApplyMap" to access this data. See Example 3 in the following Wiki page:

http://community.qlik.com/wikis/qlikview-wiki/using-mapping-instead-of-joining.aspx

good luck!