Compare two consecutive rows into for each row

Help Studio
, , ,
1

Hello guys, I have an excel with 3 columns and a flow that iterates through them with “for each row” activity…I need to set a condition where it checks if the value of column C modifies… How can I do this?
Thank you!

2

Hi ,

Can you explain abit more about it :- I need to set a condition where it checks if the value of column C modifies

3

Hello @shanmukh_pothamsetty, I have an excel file with 3 filled columns… the thing is that the third column rows have mostly the same value and I need to set a condition to find where this value modifies. (to compare two consecutive rows from column C).

4

@Ionut_Frincu First, assign the First Value Of Column C into a Variable, then You can iterate over the Datatable using For Each Row , Use an if Condition inside for Each to Check if the variable and row(“ColumnC”) value are the same or not. Then you can do the Operations Accordingly

5

Can you please give me an example on how I should set the condition of the “if”…

6

@Ionut_Frincu

  1. Assign First Row Value of Column C outside of For Each Row, Like this
    strColumnC = row(“Column C”).ToString.Trim

  2. Inside a For Each, use if Condition and use the Condition
    row(“Column C”).ToString.Trim.Equals(variable)

7

@supermanPunch I cannot use row(“Column C”) outside of For each row…

8

@Ionut_Frincu Oh Sorry My Bad :sweat_smile:, Use this :
strColumnC = DT(0)(“Column C”).ToString.Trim