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.

1 Like

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

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

@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
})
:pray::pray:

1 Like
2 Likes

Check if this helps : https://www.youtube.com/watch?v=0bTajZXBBR0