Build a linq expression for the datatable

Help Robot
,
1

I have a filter datatable with the following options selected :

image

image

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 ?

2

@Ishan_Shelke

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

cheers

3

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