Issues with Merging Datatables

Help
1

Hi all,

I wish to merge 2 datatables with 2 same column names (the tables only have 2 columns). I used the ‘Merge Datatable’ activity, however the result of the merged table is not what I wanted. Instead of merging table 2 data below table 1, it placed table 2 data on the right of table 1 data (creating 2 more columns)

What went wrong??

2

@Edmundz Merge datatable is working fine for me.

Please check below workflow.

MergeDataTable.xaml (13.5 KB)

Can u share ur workflow?

3

Hi @Manjuts90 I’m unable to open. Anyway I’m using version 2018.3.0 I do not know if there is any changes to the merge table.

1 Like
4

@Edmundz
Column names in both data table are same? Merge Data table requires exact match in column name.

5

Hi,
Refer this, It work fine !

Pic%201
Pic%201878×457 67.9 KB
Pic%202
Pic%202882×447 65.6 KB
Pic%203
Pic%203881×452 61.1 KB

1 Like
6

Hi guys. Managed to resolved it by changing the MissingSchemaAction. Thanks!!

3 Likes
7

If you are facing this kind of issue last option is just to write one table to excel and append the second data table to the same excel and use read range:)

1 Like
8

Hi there!!

Anyone knows if there is a way to merge both datatables but not merging the duplicate data?

Thanks <3

9

Hey Edmundz…whats the schema that you used finally?

10

hi! i found out that if the headers of the two tables do not match, the appended table will be added in the correct row index but wrong column index. So, check if the headers match