Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Enrichment with Table with non existent data

Avatar

Level 3

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

 

 

 

 

 

 

 

 

 

 

3 Replies

Avatar

Employee Advisor

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

Denis_Bozonnet_0-1658319766659.png

Hope this helps,

Thanks

Denis

Avatar

Level 3

@Denis_Bozonnet , I had tried that, still its not working. It works like a inner join only

 

Regards,

DG

Avatar

Employee Advisor

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

Avatar

Level 3

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

dipendu_g_1-1658335420616.png

 

dipendu_g_2-1658335704044.png

 

Regards,

DG