Replace values if the other column has values, if not leave it

How can I use invoke code or assign activity (Don’t want to use for each row and if because it’s slow)?
In order that if a 3th column has value, use this value on the 2nd column.
But if it doesn’t have a value, leave the already value of the 2nd column

How it would be the code?

Like this:


How about the following?

dt.AsEnumerable.Where(Function(r) r("SAPUnits").ToString<>"").ToList().ForEach(Sub(r)
    r("PRECIO UNIT")=r("SAPUNits")
End Sub
) (8.4 KB)


Hi @JavRR ,
Same QA,
You can try

move_index_column.xaml (24.5 KB)


Thanks!! It was what I needed

1 Like

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