UiPath | Remove Duplicate Rows from Excel / DataTable using two columns | Delete Duplicate Rows LINQ

[@TheOriginalbeat]

Mahmoud you are simply the best, thanks a lot for sharing.

[@ActAutomate]

Thanks a lot Mohammed 🙂

[@jafarbasha4394]

Tnqq for ur video, it helps me now. ☺️

[@ActAutomate]

Cool ☺️ thanks for the feedback

[@rasipogulabhaskar9858]

superb superb....

[@ActAutomate]

Thanks :-)

[@maikjunior2811]

Hi, would you be so kind as to help me know how I update the last cell of an excel data table?

[@ActAutomate]

Hi Maik. It's very easy. You need only three activities: 1. Read Range --> To read the excel file and save it in variable ExcelDT for example. 2. Assign Activity --> Create an Int32 variable (RowsCount) and set it = ExcelDT.Rows.Count 3. Write Cell Activity --> Set the name of your Excel file, set the cell = "A"+(RowsCount+1).ToString and set the value which you need to enter in Excel. This flow if you want to change the column A last cell, but if you want to change column B, you have to set "B"+ (RowsCount+1).ToString and so you can change it. If you want to change the last row completely. You need Write Cell activity for each column. This is the best and easiest way to do that. Please let me know if you need help. Best regards Mahmoud

[@maikjunior2811]

@@ActAutomate Hi thanks for taking the time to help me. Well I couldn't do what I would like. Here's what I want in a screenshot. I tried to do the way that showed me more he captures in a way that I don't know how to handle. See below >>> prntscr.com/1qbvo4a

[@dedsec5177]

how the same can be achieved in query syntax 🤔' !

[@ActAutomate]

You can do that as follows: ( From row In Excel_DT Group row By a = row("Location"), b = row("ZIP") Into grp = Group Select grp.First ).CopyToDataTable

[@dedsec5177]

@@ActAutomate Thanks Mahmoud 😊

[@ActAutomate]

@@dedsec5177 You're welcome 😃

[@rhiran9019]

@@ActAutomate thanks much. If the above is called as query syntax, then could you please let me know the term we use to refer for the syntax that you have used with .asenumerable in the video.

[@jagadish_padhi]

Hi, For example there 3 columns Column A Column B Column C ROY School Bike ROY College Bike ROY College Bike My question is i want to remove the duplicates of Column A and B and keep Column C as it is. Outcome Should come- Column A Column B Column C ROY School Bike ROY College Bike Please help

[@ActAutomate]

I already did it in another video. Please check it under the following link: kzbin.info/www/bejne/oX6winiFoNZmb9k You can select the columns you need. In your example you have to select the first two columns and set them in the code for Group. Please try it and if you don't know how to do it, just write me back.

[@ActAutomate]

you can also try this simple one: out_DT= YourDT.DefaultView.ToTable(True, {"Column A", "Column B"})

[@johncena-lf9zb]

How can we delete selected (multiple)columns ?

[@ActAutomate]

Can you please give me more details, what you want to do? for multiple columns, for example: Column A to C --> (A:C) For only one column, for example: Column Z --> (Z:Z) But if you mean something else, please write more details.

[@johncena-lf9zb]

By selecting multiple columns and removing the unwanted columns

[@ActAutomate]

@@johncena-lf9zb You mean, you want to delete each column, except the selected columns?

[@johncena-lf9zb]

@@ActAutomate yes

[@patanchanbaasha811]

Thanks for the explanation Mahmoud. Can you please give me solution for below ColumnA Column B 1234 55 1234 55 2222 55 3333 77 My question is how can we remove duplicate row i.e 2nd row. And I would like to print 1st, 3rd and 4th rows only. Please help me

[@ActAutomate]

Thanks Patan, The answer is already in the video: ExcelDT.AsEnumerable().GroupBy(Function(a) Tuple.Create(a("ColumnA").ToString, a("ColumnB").ToString)).Select(Function(b) b.First).copyToDataTable() Or you can use the following query also: ( From row in MyDT Group row by k=row("ColumnA"), row("ColumnB") into grp = Group Where grp.Count = 1 Select grp ).CopyToDataTable Please check the following videos to learn more about that: LINQ Group LINQ Filter Data Table LINQ SelectMany Just let me know, if you still need help!

[@patanchanbaasha811]

@@ActAutomate sure, Appreciate your support. will get back to you if I need any help on this. Thank you so much.

[@ActAutomate]

@@patanchanbaasha811 No problem! 🙂