How to specify pair on uipath?

Help Activities
, ,
1

image
image930×586 76.8 KB

I’d like to ask. I want to determine the last location of the person’s activity. for example joko. Joko did 7 in & out activities. if joko does activities in & after joko Out, then write OUT in the Last Location column (picture attached). but in the last activity it was seen that Joko had not left the room. then the last activity is not written OUT. I’d like to ask. what activity do I need to use to get the result like below. or do I have to use an Excel formula to get results like the picture? Please help

image
image892×594 74.3 KB

2

@wsinten

Try like this

  1. Read data into datatable dt
  2. For each row in datatable on dt and assign index variable to index property in for loop
  3. Use if condition inside index<dt.RowCount AndAlso currentRow("Person ID").ToString.Equals(dt.Rows(index+1)("Person ID”).ToString) AndAlso currentRow("Activity").ToString.Equals("In") AndAlso dt.Rows(index+1)("Activity”).ToString.Equals("Out")
  4. On then side use assign activity with currentRow("Last Location") = "Out"

Hope this helps

Cheers