Join Data Tables' Join Wizard

I’ve created a sequence that basically invokes 2 files, both of which create 2 data tables that hold a list of email addresses both with a column name Email. Added a join data tables at the end of my sequence and passed them both through the inputs and created a new argument for the output of the data table. The join type is left, and it is “Email” = “Email”. Is this correct? As I’m getting the following error:

Source: Join Data Tables
Message: Data Table 1
Exception Type: System.Argument.Exception

Any ideas where I’ve gone wrong? First time trying to excuse any ridiculous errors.


Please share the screenshot or process.xaml because i’m not understand the error

1 Like

If both datatables have a column “Email” of the same type then it should work, note that the column names are case sensitive…

Using this query this work with different dataTypes columns
(From d1 In dt1.AsEnumerable
Join d2 In dt2.AsEnumerable
On d1(“Column1”).ToString Equals d2(“Column2”).ToString
Select new with {.Column1 = d1.Column1,
.Column2 = d2.Column2


Check if this helps : Join Data Tables UiPath | UiPath Join Data Tables | Join Uipath | Uipath Join Table | ExpoHub - YouTube