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..
Best answer by DannyRyan
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.
+2Hi 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.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
