Comparing files

[Borisham]

Hello guys,

I have 2 XLSX files that I would like to know(would like to have a list) which ID's doesn't exist in File 1. both have the same fields and structure (2 same kyes).

What is the best way to achieve that ?

Thanks

[mceleavey]

Hi @Borisham ,

can you post some data so we can help?

M

[mceleavey]

@Borisham ,

The way to do this is to join the two tables on the key field(s) using the join tool.

The join output represents the matching records. The left output is the records on the left input that don't match and the right is the same for the right input.

Hope this helps,

M.

[Qiu]

@Borisham 
Just an illustration to @mceleavey  answer.