Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
Are you trying to get the output in front-end (may be in a text box)? Is your comparison case sensitive?
.
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.
.
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 .