Join Data Tables' Join Wizard

[jackcawthra]

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.

[ParasTripathi]

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

[jackcawthra]

[bcorrea (Bruno Correa)]

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

[ParasTripathi]

@jackcawthra
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
})

[ParasTripathi]

How to Join Datatable via Code

Hi, you can use below code tempDt = (From x In dt1 Join y In dt2 On x(“id”).toString Equals y(“pkgId”).toString Select tempDt.LoadDataRow(New Object(){x(“id”).toString,x(“name”).toString,y(“Location”).toString,y(“Country”).toString},False)).CopyToDatatable

[RAKESH_KUMAR_BEHERA]

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