Excel columns comparison

[Shirin_Sebatina]

Hi,

How to compare the EMP ID with the previous one?

[Palaniyappan (Forum Leader)]

Hi

Have a view on this with similar scenario

Previous row item in dataTable

Hi @rag Welcome to uipath community Great to get the current row i hope you are using for each row loop with datatable as input and getting the row index, but i would like to make a small suggestion with the way we get the currentindex, a integer variable it should be like this currentindex = dt.Rows.IndexOf(row) actually this gives the index of the current row which is getting iterated from the for each row loop in dt, the table that you pass if you get like this currentindex = dt.Ro…

Excel previous row value

Dear all, I am trying to get the previous value of “A1” column per each row. Currently, I can’t achieve that. |Site Code|Site Name|Delivery date|Item Code|Quantity| |C0001101|Ye Moe|2/9/2020|A00002|14| |C0001101|Ye Moe|2/9/2020|A00003|28| |C00017|Test Customer|2/9/2020|A00002|4| |C00017|Test Customer|2/9/2020|A00002|6| |C00017|Test Customer|2/9/2020|A00001|9| The scenario is if the Site Code is the same, that code will not be re-entry again. I am using for each row and “if” condition in …

Cheers @Shirin_Sebatina

[ashwin.ashok ((TheCodingTheory))]

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

[Gokul001 (Gokul Balaji)]

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

Regards
Gokul

[Shirin_Sebatina]

Hi,

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

[supermanPunch (Arpan)]

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.