How to output list which can't be joined

eriena
eriena Member
in Magic ETL

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".

image.png

My ETL is below.

image.png

I could join the data.

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

image.png


"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!**
  • eriena
    eriena Member

    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.

Categories