Finding duplicates against a constant column

[Bhoomika_Rasquinha]

I have a list of vendor names and addresses
I need to match based on the same address name but different vendor names

For example if this is my sample input data:

Vendor Name	Street	City	Codes
Adobe	Orchard Parkway	San Jose	95134
Cisco	Park Ave	San Jose	95110
Salesforce	San Avenue	San Jose	95119
Alteryx	West Drive	San Jose	95134
UiPath	Alameda street	San Jose	95126

How do I solve this?

[messi007]

@Bhoomika_Rasquinha,

Not sure that I undrestand well your need. What about using a unique tool 

If this does not answer your question please explain what you expect to get it will help to give you the solution.

Regards,

[Bhoomika_Rasquinha]

Hello, 

Thank you for taking time out to answer my query
But no, using the unique tool won't help me in this case

If this is my input:

Vendor Name	City	Street	PO
ABC	Bombay	GOI	1234
XYZ	Delhi	IG	5678
QRS	Bombay	GOI	1234

This is the desired output:

Vendor Name	City	Street	PO	Flag
ABC	Bombay	GOI	1234	U
XYZ	Delhi	IG	5678	D
QRS	Bombay	GOI	1234	U

[ShankerV]

Hi @Bhoomika_Rasquinha 

One way of doing this....

Many thanks

Shanker V

[Bhoomika_Rasquinha]

Hi Shanker_V,

Thank you for taking the time out and offering to help

That did not work either
Let me explain it a little more

Input:

Name	City	Street	PO
Calix, Inc.	San Jose	2777 Orchard Parkway	95134
Adobe Inc.	San Jose	345 Park Ave	95110
Infinera Corporation	San Jose	6373 San Ignacio Avenue	95119
Cisco Systems, Inc	San Jose	170 West Tasman Drive	95134
Richard Bliss	San Jose	1346 The Alameda Ste 7-113	95126
United Parcel Service, Inc	Atlanta	55 Glenlake Pkwy NE	30328
UPS Supply Chain Solutions, Inc.	Atlanta	Atlanta	30328

Output:

Name	City	Street	PO	Result
Calix, Inc.	San Jose	2777 Orchard Parkway	95134	D
Adobe Inc.	San Jose	345 Park Ave	95110	D
Infinera Corporation	San Jose	6373 San Ignacio Avenue	95119	D
Cisco Systems, Inc	San Jose	170 West Tasman Drive	95134	D
Richard Bliss	San Jose	1346 The Alameda Ste 7-113	95126	D
United Parcel Service, Inc	Atlanta	55 Glenlake Pkwy NE	30328	U
UPS Supply Chain Solutions, Inc.	Atlanta	Atlanta	30328	U

[ShankerV]

Hi @Bhoomika_Rasquinha 

As per the requirement all the city which falls under different name should be D and then with one city is U right.

Can you explain why for Atlanta it is U instead of D, as it has 2 different names. I can help tweaking the code according to your requirement.

United Parcel Service, Inc	Atlanta	55 Glenlake Pkwy NE	30328	U
UPS Supply Chain Solutions, Inc.	Atlanta	Atlanta	30328	U

[Bhoomika_Rasquinha]

Hi,

I need to perform matching based on different names but same address

U and D is for convenience 

[ShankerV]

Hi @Bhoomika_Rasquinha 

Sorry I didn't get your requirement clearly.

Its unclear what I need to assign with different names and same address.

What to assign if it has only same address and name.

What to do if many different names and address are there.

[Bhoomika_Rasquinha]

I am sorry but I don't have any information either on that at the moment

Here is what I can tell you

I need to find name duplicates, under that I need to 

For dups, we can do the following matches

Matching based on same address but different names

Hope this helps