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 |
Solved! Go to Solution.
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
@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
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 🙂
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
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.