Build a linq expression for the datatable

I have a filter datatable with the following options selected :



Since my excel is consisting of almost 2 lakh rows in it the filter datatable is not possibly the best fit for this situtaion can anyone assist in building a linq expression for the same ?


To be honest linq or filter datatable almost takes same amount of time when run in run mode or from orchestrator

But if you still need linq here it is

dt.AsEnumerable.Where(function(x) x("Match Status").ToString.Equals("Missing in PR")).CopyToDatatable

then if you ned only few columns from the original dt then use dt.DefaultView.ToTable(False,“Column1”,“Column2”…) add all column with comma separation

Hope this helps


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.