How to output list which can't be joined

Hello,

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 Coach
    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!**

Answers

  • GrantSmith
    GrantSmith Coach
    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!**
  • Hi @amehdad , @GrantSmith ,

    Thank you so much for your advices.

    I didn't realize full outer join, your advices help me very much.

    Thank you.