About Merge data tables with identical headers

Help Studio
1

Combine two data tables with the same header, e.g. table 2 below table 1 instead of to the right,I use the Join DataTable Activity,I choose full,and the table 2 at the right of table 1,not below.

2

use merge datatable activity, not join

e.g. here it will merge dt1 to dt2

image
image1203×451 18.1 KB

3

@jack.chan ,Thank your answer.I use the Merge Datatable Activity,Only data from Table 1,I can’t see the data from table 2 which after merge.

4

can you screenshot your xaml here

5

should look like this

source = table2
destination = table1
image

6

@jack.chan ,Ok,my activity option is here.But my dt1 and dt2 just the test,only one row and header.So i change them order is be ok.When I use the activity,my data just have the one of them.
QQ截图20220517164314

7

can you upload the xaml here?

8

should be like this
destination = dt1
source = dt2

then dt1 will have 2 rows
image

9

test.xaml (9.3 KB)
QQ截图20220517164329
QQ截图20220517164340
@jack.chan ,Ok,is here.And i put my test xlsx data here.

10

@jack.chan ,Oh I try it just now.Why dt1 and dt2 can’t change them order?Why must dt1?

11

change:

source = dt2
destination = dt1 !
image

12

if destination = dt2, dt2 will have 2 rows, so you output dt2…
image

if destination = dt1, dt1 will have 2 rows, so output dt1
image

1 Like
13

@jack.chan .Oh,I know it now!Thanks ur patience answer!

1 Like
14

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