Comparing Columns - Excel


When comparing two columns, for example Column A and Column B
Can i do if A has a row with a value greater than 0 to update that same row in B to say “Updated”

All help is greatly appreciated!


yes of course we can do that
–use a for each row loop and pass the datatable obtained from the read range activity
–inside the loop use a if condition like this
Convert.ToInt32(row(“columnAname”).ToString) > 0
if the condition passes it will go to THEN part where we can use a assign activity like
row(“columnBname”) = “Updated”

Cheers @shawnmurray

1 Like

Thanks @Palaniyappan

I will try this and let you know how it goes


1 Like

Kindly let know
Cheers @shawnmurray