Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
LEFT OUTER JOIN VisualInspection VI ON VI.ConsigmentID = INSP.ConsigmentID 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
How can I achieve this in QlikView? I can't find any examples for joining like this in Qlik
VI:
VI.ConsignmentID as ConsignmentID,
if(not isnull(VI.ItemCode), VI.ItemCode, 1) as ItemCode
from VisualInspection
;
left join (VI)
INSP.ConsignmentID as ConsignmentID,
if(not isnull(INSP.ItemCode), INSP.ItemCode, 1) as ItemCode
from INSP
;