Split Excel into three distinct sheets

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!

Duplicate of

1 Like

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:

Sol

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

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

Best regards,
Marius

2 Likes

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

And yet it still does not!

1 Like

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.

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.

image

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)