How to use Add data row Activity

I have two datatables dt1 and dt2
dt1 contains
col1 col2 col3
47i ruk yfk
43 tulr6 lyruf

dt2 contains
col1 col2 col3 col4
xfy ruk zsr jcyf
stv tulr6 tdck hvc

and there is one more datatable which is empty i.e dtEmpty
I need to take 2 add datarows activity for for dt1 and one for dt2.

So,How to fill the dtEmpty
Bcoz my requirement is I need to take 1st row of dt1 in empty datatable then 1st row of dt2.Again 2nd row of dt1 and second row of dt2

plss help


If count of dt1’s rows is same with count of dt2’s rows, the following will work. (3.0 KB)


No datatable rows are not equal

column size of dtEmpty is same as dt2

How about the following? (3.3 KB)


Here you have provided in second add data row activity
what does it means?
and wht is idx?

what activity u have used here above write range?
It is not availble in my project.
Pls provide the package name nd activity name


This returns items in idx-th row as object array.

wht is idx?

It’s index number of Dt1 or dt2’s rows.

Pls provide the package name nd activity name

Please see the following image.



activity which is used above write range

Can you clarify your problem?

In this xaml which activity you have used above write range.I m not able to see the activity in my project

please provide screenshot , so @Yoichi can understand better on the issues

regards ahmad


Which compatibility do you use? if you use cross platform, you need to install Excel.Activites Package from Manage Packages as the following.


What if I want dt2 values at a specific position of DtEmpty


can we try like this

in first for each row read dt1->CurrentRow1.
take one more for each row and read dt2->CurrentRow2.

in add data row mention dt as your outputdt.

The output excel look like: col1-dt1|col1-dt2|col2-dt1|col2-dt2|col3-dt1|col3-dt2

in array of row mention like this:


in write range mention the dt as outputdt.



We need to use DataRowColection.InsertAt method with InvokeMethod activity.


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