Split Excel into three distinct sheets

[Yudhisteer_Chintaram]

Hi,

I have this excel data which I would want to be split into 3 excel sheets.
I could only do delete duplicate values.

1. Retrieve only the unique Invoice number and write it in an excel sheet.
2. Retrieve the first row only based on duplicate Invoice number and write it in an excel sheet.
3. Retrieve the other rows of duplicate Invoice number and write in an excel sheet.

Thanks for the help!

[prasath17 (Guru)]

Duplicate of

Split excel into Unique and Duplicate Rows

@Yudhisteer_Chintaram1 we implemented sucessfully a lot of scenarios handling duplicates, groups, takinng uniques, taking first from group etc. And we got it working. But from a feedback “is not working” we cannot derive what exactly is not working at your end. Also we do not know on what have you implemented so far. For this we asked you on details. Fell free to share it with us, so we can better help you or manage it by your own. Thanks

[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

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

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

And yet it still does not!

[zohebykhan (Zoheb Khan)]

SplitExcel.zip (10.4 KB)

@Yudhisteer_Chintaram : I’ve added the solution, please mark the thread closed with a solution. I took your input sheet and cleaned it up.
@Others: Please do let me know if you have any inputs / comments on the solution provided, its always better to learn more.

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

Thanks a lot for the help!!

However, in the "“FirstRecord” sheet, there should not be Tom and Cob.
We should remove the single entries first and take the first row of every batch entries. The rest are fine.

[zohebykhan (Zoheb Khan)]

True, with the available variables in the solution, this last step shouldn’t be a pain to achieve.
I hope you are good with that.

I’ve attached the updated solution herewith.
Main.xaml (21.1 KB)