Duplicate items

[Navya08]

I have an expense sheet , and i need to check duplicate expenses from all employees

1) i need to identify same amount, same transaction date,same employee id but different payment method personal credit card or cbcp.

2) same amount, same employee id but diff payment method .

can someone help me how can  i get through this and highlight the duplicates with yellow

[davidskaife · Accepted solution]

Hi @Navya08 

You could try this as one way of doing it; using the Summerize tool group by the required fields (Amount, Transaction Date, Employee ID) and count Employee ID. Then create a Duplicate field using the Formula tool, where if Count is > 1 then its a duplicate, otherwise its ok. Finally join it back onto the original data using the same fields you grouped by.

[Navya08]

Thank you

[Navya08]

@davidskaife On wider data it is working fine to highlight duplicates but i am not able to flag those where payment type is different

[Navya08]

i.e need to identify same amount, same transaction date,same employee id but different payment method personal credit card or cbcp.

[davidskaife]

Hi @Navya08 

that's what it should already be doing? Can you provide your expected output for both scenarios?