How to join tables for matching fields

[Anonymous]

Hi all,

I have two tables A and B. Table A can have more rows compared to table B.

Now I need to compare for exactly matching fields of table B from table A. But I also want to maintain total count, matched count and unmatched count in the data model.

In this case, how to join these two tables and get these data without duplicates. Also attached some sample data with this.

Please help.

Thanks,

Siva.

[passionate]

Hi Siva,

You don't need to join for getting your results.

You can use applymap.

PFA Solution

Regards,

Pankaj

[Anonymous]

Thanks Pankaj. But I need to compare the combination of three columns using autonumber function. In that case, applymap is possible?

[passionate · Accepted solution]

Hi Siva,

Follow below steps:

Concatenate the three fields to form a single field eg: Feild1&field2&field3&field4

Then use this field in Applymap with same logic.

This would work.

Regards,

Pankaj