Split Excel into three distinct sheets

[Marius_Puscasu]

Split excel into Unique and Duplicate Rows

Hi, I have this excel data which I would want to be split into 3 excel sheets. Retrieve only the unique Invoice number and write it in an excel sheet. Retrieve the first row only based on duplicate Invoice number and write it in an excel sheet. Retrieve the other rows of duplicate Invoice number and write in an excel sheet. UIPath_Excel_Scratch (3).xlsx (9.9 KB) [Batch_Bot (7)] Hope you can help! Thanks!

Hi @Yudhisteer_Chintaram ,

You seem to be a smart guy, you’ve attended courses such as DeepLearning.AI, Building AI Powered Chatbots without Programming - IBM (as per your LinkedIn profile) and it would be kind of a shame not to take a look over the UiPath Accademy courses:

Your issue could be easily solved by using only 4 basic UiPath activities:

• The Filter Data Table activity (https://docs.uipath.com/activities/docs/filter-data-table)
• The For Each Row activity (https://docs.uipath.com/activities/docs/for-each-row)
• The If activity (https://docs.uipath.com/studio/docs/the-if-activity) and
• The Write Range activity (https://docs.uipath.com/activities/docs/excel-write-range)

And, please don’t be so lazy in providing feedback to community’s good intention to solve your issue

Split excel into Unique and Duplicate Rows

Does not work!

Best regards,
Marius