How to eliminate which does not have matching code and coming multiple times in a row

[Sshasnk]

Primary code	Primary_Unique_ID	Sec_Unique_Id	Sec code
CA	123	645	WB
EC	456	903	KL
EC	456	903	EC
KM	656	839	KM
EC	879	519	NA
EC	879	519	EC
EC	879	519	NA

I have to eliminate the above record: on 2 conditions

1. If it is coming multiple times

2. Primary code = sec code

Expected Output:

Primary code	Primary_Unique_ID	Sec_Unique_Id	Sec code
CA	123	645	WB
EC	456	903	EC
KM	656	839	KM
EC	879	519	EC

[AngelosPachis]

That is correct @Sshasnk . To solve this without a unique tool, I think you should help us understand what you mean by saying "A record comes in multiple times"

How do you define a record multiplication? Is that based on Primary Code, Primary Unique ID, Secondary Unique ID/Code or a combination of all of the above?

Then I think we can solve it with another way, but it is still ambiguous what you are looking for exactly

[Sshasnk]

@Emil_Kos  Sorry Cant share the canvas as it comes under risk, but I can tell you what I tried. I was using summarize tool to count multiple records (using count) and filtering where the count is more than joining it back and checking primary code = sec code and using joining all of them back together  

[Emil_Kos]

Hi @Sshasnk,

Sounds like you have replaced the duplicated tool with join tool. It strange that duplicate didn't met your needs but happy that eventually it worked for you 🙂 

[Sshasnk]

@AngelosPachis 

Primary code	Primary_Unique_ID	Sec_Unique_Id	Sec code
CA	123	645	WB
EC	456	903	EC
EC	456	903	KL
KM	656	839	KM
EC	879	519	EC
EC	879	519	NA
EC	879	519	NA

So if you will see above 456 (Primary_Unique_ID ) and 903 (Sec_Unique_Id) is coming twice (multiple records) -> same goes for record 879 and 519

and if you will see 456 and 839 it is only coming once (single record) -> same goes for 123 and 645

[AngelosPachis · Accepted solution]

Hi @Sshasnk 

Your explanation really helped me. I think another approach is similar to what you described to @Emil_Kos , which you can find below

Let me know if that worked for you please

[grazitti_sapna]

Hi @Sshasnk, my workflow is similar to what @AngelosPachis  has prepared.

Thanks.

[grazitti_sapna]

HI @Sshasnk , @AngelosPachis  another possible way to solve this problem.

Please mark this post as solution if this is what you are looking for?

Thanks.