Compare two rows in the same Datatable

[Asghany (Joao Bernardino)]

Hello RPA lovers,

How to compare two consecutive rows of the same Datatable and if they are the same remove the second one?
I don’t have names assigned to datatable headers
I hope some experts can help me =D

[MartianxSpace (Chitti)]

@Asghany You can use “Remove Duplicates Range” activity to remove all the duplicates in the Data Table. You can use Remove Duplicates too.

[AshwinS2 (Ashwin S)]

Hi @Asghany

Use an if condition

Row(“columnname”).ToString.equals(row(“columnname”)
Use remove data row activity

Thanks
Ashwin.S

[supermanPunch (Arpan)]

@Asghany Remove Duplicae Rows From Datatable and write the new DT to new Excel File.

[Asghany (Joao Bernardino)]

@supermanPunch @MartianxSpace @AshwinS2

Thank you for your quick answers.
Remove duplicates will not work, since I want to remove accordingly to one column specification and not the all row.
Row(“columnname”).ToString.equals(row(“columnname”) will also not work because I don’t have headers names on my columns

[MartianxSpace (Chitti)]

@Asghany IF you don’t have header name then you can use row(0).ToString

[Asghany (Joao Bernardino)]

@Asghany

Row(“columnname”).ToString.equals(row(“columnname”)

You are talking about this right? Row(“columnname”).ToString.equals(row(“columnname”)

But row value will be the same.
I want to compare the row(0) wit row+1(0)

[supermanPunch (Arpan)]

@Asghany If No Headers are available , then when you read the File , Uncheck Add Headers Option, in that way by default you will get ‘Column0’,‘Column1’,… as the headers

[Asghany (Joao Bernardino)]

@supermanPunch

‘Column0’

Like this?
dt_Sorted_2.AsEnumerable().GroupBy(Function(a) a.Field(Of String)(‘Column1’)).Select(Function(b) b.First).CopyToDataTable()

[supermanPunch (Arpan)]

@Asghany Sorry Double Quotes “Column0”

[Asghany (Joao Bernardino)]

Yeah, my bad…I inserted " " later.

This error pops up

[supermanPunch (Arpan)]

@Asghany Seems Like there are no rows after you GroupBy