Compare common clumns of two diffrent tables and write the values. using linq method syntax

image

image

Hello @Pujari_Manjunatha
What output you want can you explain. you want to join tables on basis on WIID using linq Query?

image

use join datatable activity it will do the same as linq

Regards

I want to know how to write linq for it.

Hi @Shubham_Kinge

Check out this once

Regards,

@Pujari_Manjunatha

(From a In Dt1.AsEnumerable()
            Join b In Dt2.AsEnumerable()
            On a("WIID") Equals b("WIID")
            Select OutputDataTable.Rows.Add({a("WIID"), a("Description"), a("Type"), a("Date"), a("Total"), b("Discount")})
).CopyToDataTable()

@Pujari_Manjunatha

Did you build the output datatable with the output column names?
And the column names must match with output datatable

Regards,

Hi @Pujari_Manjunatha
In my case it is working

If not working please go through below link for your reference

Yes, I need to add those columns to the final output data table. Then only it will work. Thanks for suggesting.

Can we write the same logic using method syntax?

You can refer the above attached video for different methods and below link.

try below steps to add columns to output datatable

Use assign activity in that outputdt = dt1.clone() here dt1 is datatable which has all columns

next use add data column with name that you are appending

Regards