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

[JavRR]

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:

[Yoichi]

Hi,

How about the following?

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

Sample20230810-1L.zip (8.4 KB)

Regards,

[Nguyen_Van_Luong1 (Nguyễn Văn Lương (Albert Nguyễn))]

Hi @JavRR ,
Same QA,
You can try

How to import data from one excel file and put it in the desired column in another excel file?

Hi @Famui_Yanisa , I think you want to write column C in file1 to column Animals (A1) in file2, column B to A-Z, and column A to Column Number(C1) You can -use excel read range file1 -filter data to get column what you need keep -use write range to file2 My in/out [image] My code [image] [image] [image] regards,

move_index_column.xaml (24.5 KB)

Regards,
LNV

[JavRR]

Thanks!! It was what I needed