Split excel into Unique and Duplicate Rows

Help Activities
, ,
1

Hi,

I have this excel data which I would want to be split into 3 excel sheets.

  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.
    UIPath_Excel_Scratch (3).xlsx (9.9 KB)

Batch_Bot (7)
Batch_Bot (7)793Ă—1121 76.9 KB

Hope you can help!

Thanks!

3

Can you help please?

4

@Yudhisteer_Chintaram1
find starter help here:
FindDupsUniquesFirstFromGroup_By1Col.xaml (9.3 KB)

1 Like
5

Hi @ppr

Can you provide source for learning LINQ?

Thanks

6
1 Like
7

Does not work!

8

Please provide always details on what is not working. Only with this feedback we can help you. Thanks

9

So in other words you don’t know how to do it?

10

@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

1 Like
11

I think there is a duplicate thread regarding the same topic.

@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.SplitExcel.zip (10.4 KB)