Different document numbers for the same purchase order

Hello Everyone,

Below sheet I have to get different document numbers for the same purchase order. (same purchase order under different document no.)

Input table

Document No Purchase Order
01 123
02 246
03 456
01 123
01 123
03 123
03 456

Output Table

Document No Purchase Order
03 123

Please support me to solve this issue.

Hello Udesheyy,

I don’t know if I understood your problem correctly, but I think that you can do the following:

  • Use Remove duplicate Rows on the full dataTable
  • Count the occurrence of every document: if a document is counted more than one it means that the same document is present twice (or more) with different PO.

Let me know if it works.

Regards,
Stefano

@stefano_negro Thank you soo much. I will check and let you know

Sign Up Log In