The idea is:
right now the merge node has two modes that can be compared to SQL join:
- merge by key - behaves like inner join
- multiplex - behaves like outer join
Please add left join, which retains items from the first input when there’s no matching item in the second input
My use case:
My items have a field, say company_name, that I need to fill based on another field which might be empty, say, company_id.
I take all companies and try to merge it using company_id as the matching field.
If company_id is missing or otherwise not matching, I’d like to keep that item in the output.
I think it would be beneficial to add this because:
Left join is quite common in SQL and merge node looks like it’s supposed be something similar