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?
How about the following?
Sample20230810-1L.zip (8.4 KB)
You can try
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)
-use excel read range file1
-filter data to get column what you need keep
-use write range to file2
move_index_column.xaml (24.5 KB)
Thanks!! It was what I needed
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.