Insert into coloum A by comparing Value of Coloumn B

How to update coloumn based on data in coloumn B
For example
Col a|||Col b
A |||B
A ||| ____
A |||B
I want to update if col a = A then colb = B if its something else just skip it/leave it as it is.

use a ‘for each row’ activity

if row.Item("ColumnA").ToString.Equals("A")
    row.Item("ColumnB") = "B"

Do you think we need to update datatable?

using asign activity, that will update the DataTable

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.