Get counts of matching users

[sujit_nath]

There is a scenario – CID | email | mobile, Now a file is provided from 3rd party containing email and mobile in same column – “email mob” the rows will either contain mobile or email of customers. How do I know which customers have record in the base table? For one customer it may be possible that either email, or phone or both email and mobile are mentioned.

[Arthur_Fong]

What is the end goal here?

If the columns in base data are empty, then update with 3rd party data?

[sujit_nath]

No, Just want to get the counts of users which have email/mob no in the excel file, that has a mapping with actual data.

[Arthur_Fong]

Can you provide a sample base data and a sample 3rd party data you mentioned above?