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.

[Anirban]

Hi @michelle653burkes 

If i do left join then if data is available in the 2nd table, then Value 2 doesn't get populated.

I am working with a list of files. Some files will have value in the 2nd table, some will not. I am trying to create a common workflow which will help me get data for both the cases

[nagakavyasri]

@Anirban Union the outputs from J and L anchors.