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.