Hello @Pujari_Manjunatha
What output you want can you explain. you want to join tables on basis on WIID using linq Query?
use join datatable activity it will do the same as linq
Regards
I want to know how to write linq for it.
(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()
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