UiPath Academy - Data Manipulation with Data Tables in Studio, Merge DataTable Issue

Help Studio
1

I’m at Working with DataTable variables Part 2. I have followed every instruction step by step and it is perfect… bar one thing. At the first ‘Merge Data Table’, MissingSchemaAction is set to Add. At the second, it is set to ignore so that it doesn’t duplicate columns. No matter which way I try to mix and match and reorder things, it either duplicates the columns anyway or in the case that I set them both to ignore, it just doesn’t work at all.
Shown are the activities Merge Data Table 1, Merge Data Table 2 and the resulting excel file:

uipath problem
uipath problem1597×1177 227 KB

2

HI,

It seems MergeDataTable works well in my environment.

First, dt_Candidates has 5 columns : FirstName, LastName ,Department , Role, Status.
And dt_HRCandidates has also same name 5 columns : FirstName, LastName ,Department , Role, Status.

MergeDataTable returns 5 columns FirstName, LastName ,Department , Role, Status, because there are no mismatch column.

Next
dt_ProductCandidates has 7 columns: First Name,Last Name,Department,Role,Product Certification,Status

So MergeDataTable ignore mismatch column (Role and Product Certification),and return 5 columns : FirstName, LastName ,Department , Role, Status as the following image

image
image1412×716 76.7 KB

It seems normal behavior, I think.

Regards,