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.
+4that’s a messy solution. You need to convert non-string fields to string first etc.
Ataccama should really grant us support to use a join on multiple key fields..
+4For the record, the above solution is nothing more than a Column Assigner added to a stream, that then does a sum of the fields in between.
<assignment expression="src_id + "|" + src_name" column="pur_join_key">
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
