How to output list which can't be joined


I would like to know how to output list which can't be joined.

I would like to join two list as below with "Product".

My ETL is below.

I could join the data.

I would like to make one more output as below data.

"grape" in Product in left list is not existed in right list.

So I would like to output this data as well.

How do I set this method by ETL?

Thank you.

Best Answers

  • GrantSmith
    GrantSmith 🥷
    Answer ✓

    You wouldn’t necessarily need a full outer join as the left join would work just fine. After your join just add a filter tile to say where shop is null and then feed that into another output dataset

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**