Hello,

How to write the following condition in Ataccama Desktop (Join step):

left join anl.productsjur p on (asd.creditpurpose = p.cp or coalesce(asd.creditpurpose, p.cp) is null)
                        and (asd.creditpurpose2 = p.cp2 or coalesce(asd.creditpurpose2, p.cp2) is null)
                        and (asd.creditobject = p.co or coalesce(asd.creditobject, p.co) is null)

The difficulty is that in the join step only one field for left key and right key is available for selection..