How to output list which can't be joined

eriena

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.

amehdad

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

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

amehdad

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

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

eriena

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.