?

[xyz1]

.

[tresB]

Are you trying to get the output in front-end (may be in a text box)? Is your comparison case sensitive?

[xyz1]

.

[tresB]

Try expression like:

For case INsensitive match (in text box)

='All match : ' & If(not Max(upper(Name)=upper(Name2)), 'NO', 'YES')

Case sensitive

='All match : ' & If(not Max(Name=Name2), 'NO', 'YES')

To get the list of names:

='Not Matched Name : ' & Concat( Distinct If(not Name=Name2,  Name), ',')

='Not Matched Name2 : ' & Concat( Distinct If(not Name=Name2,  Name2), ',')

If you need case insensitive result, just use upper()/lower() like shown above.

[xyz1]

.

[Anonymous]

Is there any relation between two tables that you are loading?? If not, i think we should create one and then replace

Name and Name2 with Assetname and Item .