Excel columns comparison


How to compare the EMP ID with the previous one?


Have a view on this with similar scenario

Cheers @Shirin_Sebatina

Hi @Shirin_Sebatina ,

What exactly do you want to compare them with?
Also, if you could share the expected output with us, that would put us in a much better position to assist you.

Kind Regards
Ashwin A.K

Hi @Shirin_Sebatina

Try this below expression it will compare the excel value based on 2 column and also provide more information so it will help us to solve your query

DtMaster.AsEnumerable.Select (Function(x) x("EMPLOYEE ID").ToString.Trim.Equals(x(ColumnNameOrIndex).ToString.Trim)).ToArray



For every different emp ID , I have to clear the details in the portal 1st and then add details

if the emp ID is same then Deleting activity should not perform directly it has to add the details

Hi @Shirin_Sebatina ,

Assuming you have to Perform UI Automation taking into consideration the no. of records provided.

Using the For Each Row Activity to Loop Through Datatable, we should be able to Store the Value after the First Iteration, which could be then Considered as Previous Value for the remaining records.

The Design would look something like this :

Also maybe sorting of the Values based on Employee ID Column should be done before the Loop if the same ID’s are not grouped together.

Let us know if this doesn’t help and maybe explain it in a bit more detail.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.