Insert into coloum A by comparing Value of Coloumn B

Help
1

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.

2

use a ‘for each row’ activity

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

Do you think we need to update datatable?

4

using asign activity, that will update the DataTable

2 Likes
5

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