Skip to main content

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..

Hi FCB developer,

The Join step allows for join conditions of either a single column or an expression.
If required, this will allow you to define join conditions based on multiple columns.

I have attached an example of preparing a joining key which consists of more than one column.

 

 

@DannyRyan thank you! 

Reply


Community Terms of Use & ConditionsCookie settings