How to do this type of Join in QlikView

[neerajthakur]

LEFT OUTER JOIN VisIn VI ON VI.ConsID = INSP.ConsID AND CASE WHEN VI.ItemCode IS NOT NULL THEN VI.ItemCode ELSE 1 END = CASE WHEN VI.ItemCode IS NOT NULL THEN INSP.ItemCode ELSE 1 END

Hi, everyone how can I do this type of join on this logic in QlikView.

[Gysbert_Wassenaar]

In both tables redefine the ItemCode field (or create a new field in both tables) as Alt(ItemCode,1) as ItemCode. If you do that a LEFT JOIN will join both tables as you want since both tables contain the fields ConsID and ItemCode.