How to update the data table in between for each row after deleted a record in excel sheet

[anilkumar.vegi]

hi Team,

i have excel sheet with 4 rows.
i want to remove the duplicate records.
i applied logic read range into Data table and compared with other columns.

now i removed 1,3 rd and 4th rows and inserted into other excel sheet. then already data is contains the data table with 4 records but reality is deleted the 3rd, 4th and 1 st rows.
it is trying to find the any duplicates with 3 rd row. and found 4th row so in excel sheet again adding 3rd, 4th row second time. any suggestions. how to update the data table data inside the for each row.

[Srini84 (Srinivas Kadamati)]

@anilkumar.vegi

Check below post for your reference

Tutorial : How to Calculate difference between two Time Values using UiPath

Hello @Srini84! It seems that you have trouble getting an answer to your question in the first 24 hours. Let us give you a few hints and helpful links. First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic. You can check out some of our resources directly, see below: Always search first. It is the best way to quickly find your answer. Check out the [image] icon for that. Clicking the options button will let you set mo…

Dt.Rows(index).Item(ColumnName).ToString = Your value

Hope this helps you

Thanks

[sshubham.agrawal93 (Shubham Agrawal)]

If the requirement is to remove duplicate rows. You can simply use Remove Duplicate rows activity.

[anilkumar.vegi]

Ya Shubham i applied same activity… thanks You

[sshubham.agrawal93 (Shubham Agrawal)]

Great!