Excel columns comparison

[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