Join Data tables does not work

Help Studio
, ,
1

I have two tables and each has a common column. I tried to join that column to check if the values match using Join data table activity, and the result doesnt have the DT2 value.

image

The two tables have the same values so the result should have matched values like this below:
image

However, I get this:
image

The data type of the two data tables are the same.
Also there is no duplicates on the two data tables.
I tried switching the tables in the Join Data Table activity, but the results are the same: the input data table2 values do not show up.

Why they are not joined?

2

Hey @yesterday

Put DT1 as Input Data Table 1 and DT2 as Input Data Table 2.

Also column Name in Activity for both table should be delivery only. Now your activity should look like this
image

I think this should solve your problem

3

Hi Yesterday,

I think your configuration is correct as I have tried and get the expected results.
Moreover, you can use output datatable activity to verify if you are getting correct results or not.

Also note that, check the “save changes” checkebox in excel application scope if using it.

Please find below response:
image

4

Hi @NIKHIL_ZAMBARE

Please have a look into the steps in the below video by @AndersJensen

Hope it will solve ur issue

Regards
Sudharsan

5

Hi @yesterday

To join to two datatable use the following LINQ:

var JoinResult = (from p in DT1.AsEnumerable()
join t in DT2.AsEnumerable()
on p.Field(“Delivery”) equals t.Field(“Delivery”)
select new
{
ProductName = p.Field(“Product Name”),
BrandName = p.Field(“Brand Name”),
ProductCategory = t.Field(“Product Category”),
TaxCharge = t.Field(“Charge”)
}).ToList();

This will get the data into a list. Now to convert list into Datatable, apply loop on the list and In the ArrayRow property of ‘Add Data Row’ activity, just supply the single string as an array,designated by curly braces {}

So it should be {item} in the ArrayRow property (or whatever you named the for each variable)

Happy Learning
Achal Sharma

1 Like