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

  • amehdad
    amehdad 🟣
    Accepted Answer

    Hi @eriena, is your use case related to getting a list of products that don't have an assigned shop and then you (or other users) can go back to that dataset 2 to correct/update it? If so, you can have a full outer join (i.e. giving you all the records from both tables and joining matching records where possible) setup and then add a Filter tile to only include any rows where you have a product but no shop. So it would go: Join tile -> Filter tile -> Output tile.

  • GrantSmith
    GrantSmith Indiana 🥷
    Accepted 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