How to find same values in datatable?

[ozgecatak]

Hey there! I have to find same Invoice ID and same Invoice Amount values for my project. A little piece of my project here. How can I find it ?

I should find AAA001 which has 10.

[Nithinkrishna]

Hey @ozgecatak

Do you mean you want to find duplicate values ?

Thanks
#nK

[ozgecatak]

Yes, I want to get same ID name and they have to same Amount too

[supermanPunch (Arpan)]

@ozgecatak

Hi @ozgecatak ,

Could you also provide us with the Output that is required for this Input ?

So that we can understand what operations that we would have to perform on the data.

[ozgecatak]

I have 49000 Invoices. I have to find invoices which have same Invoice ID and same Inovice Amount at the same time. If my Invoices group have like this type of invoices, I can’t agree with my bank.

[supermanPunch (Arpan)]

@ozgecatak ,

For an Initial Check, Try using Remove Duplicate Rows Activity.

1. Read the Excel sheet as a Datatable using Workbook Read Range Activity.
2. Use the Output Datatable from Read Range as the Input in the Remove Duplicate Rows Activity.
3. Use the same datatable as the Output Datatable for the activity.
4. Write the Datatable to a new Sheet in Excel file using Workbook Write Range Activity.

Let us know if this satisfies your requirement or it still doesn’t solve the issue.