I am using the below query to get unmatched records based on a column. When i use the query getting the below error. Any assistance on where i am doing wrong
Assign activity in the value field
dt1.AsEnumerable().Where(Function(row) Not dt2.AsEnumerable().Any(Function(x) x(“Employee Code”).ToString.trim=row(“Employee code”).ToString.trim)).Copytodatatable
I am sure i am using VB only in the workflow as language because i remember selecting VB option. Not sure how to check now and confirm you with screenshot
@Sasikanth
Use below one dt1.AsEnumerable().Where(Function(row) Not dt2.AsEnumerable().Any(Function(x) x("Employee Code").ToString.trim=row("Employee code").ToString.trim)).Copytodatatable()
(from row in dt1.Select where (from item in dt2.Select where item("Employee Code").ToString.Equals(row("Employee Code").ToString) select item).ToList.Count>1 select row).ToList.CopyToDataTable()
You can check in the bottom right corner of studio, it should say the selected language and whether you used Windows, Windows-legacy or Cross Platfrom. See here:
You should see it in the project.xaml file then, just open it with notepad instead of Studio and search for VisualBasic, if it’s in there it’s most certain a VB project.
When you do this also verify that you find:
<x:String>System.Linq</x:String>
Sometimes it also helped me on older Studio Version to Import LINQ into project through Import Panel (next to Variable/Arguments)
show us more from the surrounding modellings and the configured variables (variable panel). When for each activities are in use then also check the correct set typearguments