Outer Join

Hi!

I hope that you are doing well.

In the join recipe we offer:

• Left Join which keeps all rows of the left dataset and adds information of matched records from the right dataset.
• Outer Join which keeps all rows from both datasets, combining rows where there is a match. This is useful when you need to retain all the information in both datasets.

(You can find all available join here: Concept | Join recipe

Here i believe that the best match to a Left outer join would be to use Left join.

What is your exact need? Is there any limitation encountered using left join here? If so let me know so we can find the best way to cover your use case.

Best,

Yasmine

Yes! You can use a prepare recipe with the Filter rows/cells with formula processor: https://doc.dataiku.com/dss/latest/preparation/processors/filter-on-formula.html

There are a few approach you can take here but this processor would be the easiest option i believe:)

Best,

Yasmine