I want to add two data column to a datatable from another one like this.
My aproach is here.
Step1. Use “For each row” activity with dt2 and get dt2.row(0) and dt2.row(1).
Step2. Select dt1 and get row index.
Step3. Use “Add data column” activity and add dt1.row(2) and dt1.row(3).
Step4. Assign dt2.row(0) to dt1.row(2) or (3). (this step will also use the same method)
I have no idea of Step2 method.