Hello All,
I am getting a list of Recipients from the query in the workflow activity.
What I need to do is take the ISO value of the Recipient Location and Query another external table to fetch some data basis the Location.
i.e if Recipient Location ISOValue = External Table ISOValue, then fetch another column from external table
Here the issue is Recipient Location might have few values, which need not be present in the external table. In those case I need the column value to be blank or null ( Like an external Join )
When I use enrichment, -> Additional Data and Simple Join, it doesn't list those records not present in External Table, ( behaves like a inner join )
What should be the best method to fetch both existent and non existent data ( blank/null) from the external table
Regards,
DG
Views
Replies
Total Likes
Hi @dipendu_g
In the Enrichment, when you select the type of link, you have the choice to set the cardinality of the link you define, in your case you have to select 0-1 cardinality
Hope this helps,
Thanks
Denis
@Denis_Bozonnet , I had tried that, still its not working. It works like a inner join only
Regards,
DG
Views
Replies
Total Likes
Hi @dipendu_g
Could you share the screen shot of your Enrichment activity, all screens, something is wrong because it does work all the time. Are you sure the data type of the fields used by the join is the same?
Thanks
Denis
Views
Replies
Total Likes
Hi @Denis_Bozonnet ,
What I am facing is now, if I try to add an output column from external table, it works like inner join and if no column is added all the records are shown ( like Outer Join )
I am at total loss, where is the issue
Regards,
DG
Views
Replies
Total Likes
Views
Replies
Total Likes