Join 2 tables only if value is present in the 2nd table

Anirban

Hi All,

I am trying to join 2 tables based on a key value in both the tables. It works completely fine when both the table returns any value.

However there are scenarios where the 2nd table might not return any row. In that case only the content of the 1st table should show up. If I am joining 2 tables in this scenario, I get a blank output since no data is available in the 2nd table. 

Can anyone of you provide a solution on how to achieve the join ONLY when the 2nd table has some values in it.

Join Based on Conditions.xlsx

nagakavyasri

@Anirban Union the outputs from J and L anchors.

12-02-24.2.yxmd