Identify which fields did not match in a join

Hi,
I am building a workflow that has a join looking at matching multiple fields from the 2 sources.

Wanted to know if there is a way I can identify which fields in the left and right outputs did not match and remain unjoined.

Is this possible to do?

Thanks in advance.

Workflow

Join

Accepted answers

bhrmitra

Hi akaash,

Please have a look at the below solution. Now this is dynamic. I guess this is what you were asking

Untitled picture2.png

If this solves your issue please mark the answer as correct and also hit the like button, if not let me know! I've attached my workflow for you to download if needed.

Thanks,

Abhra Mitra

Identify which fields did not match in a join - Final.yxmd

All comments

mceleavey

Hi @aka_ash ,

That's what the left and right outputs are.

The left output is those items from the left input that did not match, and the right output is those form the right input that did not match.

aka_ash

Appreciate the quick response @mceleavey .

I realised i forgot to mention that i am using the Join by specific fields option.

I can see some items that match all the specified fields and can see the rows that did not meet all the specified fields but they do match some of those fields.

Is there a way to highlight which of the specified fields it did not meet?

Thanks,

Ash

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335