Linq to filter data

[Ray_Sha1 (Ray Sha)]

Hi,

I have a datatable which looks like the image below.

Input:

I want to filter the datatable based column Actual where the values is yes
Output:

Is it possible?

Thanks!

[Dharunya_Devi (Dharunya Balakrishnan)]

Hi @Ray_Sha1 ,

Use filter datatable activity and use the below condition,

[Gokul001 (Gokul Balaji)]

Hi @Ray_Sha1

How about this expression ?

Dt.AsEnumerable().Where(Function(w) r("Actual").Tostring = "Yes").CopyToDataTable

Regards
Gokul

[Ray_Sha1 (Ray Sha)]

Hi,

This is giving me blank datatable.

Thanks!

[raja.arslankhan (Raja Muhammad Arslan khan)]

@Ray_Sha1
Use assign activity
Left side put dataTable
On right side put this one

DT.AsEnumerable()
.Where(r => r.Field(“cloumn name”) == value)
.CopyToDataTable();

[raja.arslankhan (Raja Muhammad Arslan khan)]

@Ray_Sha1
I think when you are reading data table it is saving Actual column as ColD…please verify by printing datatable after reading from excel. You will find out where is problem.

[Burcin_Erden (Burçin Erden)]

Hi @Ray_Sha1

Try this one,
dt_ExcelTable.AsEnumerable().Where(Function (r) Not r(“Actual”).ToString.Trim.Equals(“Yes”)). CopyToDataTable

Regards

[raja.arslankhan (Raja Muhammad Arslan khan)]

@Ray_Sha1 please check datable after reading, how its look like. I have been faced this kind of issue already

[Ray_Sha1 (Ray Sha)]

Hi,
In The required solution in need the second row as well.
The solution work’s fine, but the second row is getting eliminated.

[raja.arslankhan (Raja Muhammad Arslan khan)]

@Ray_Sha1 can you show me for more clarity

[Ray_Sha1 (Ray Sha)]

@Gokul001 the solution is works fine.
But the input excel after reading is as shown in below image:

The

Output required is

[raja.arslankhan (Raja Muhammad Arslan khan)]

So After apply query its also taking Actual Empty values

[Gokul001 (Gokul Balaji)]

That you get the correct Output using Linq @Ray_Sha1

[Ray_Sha1 (Ray Sha)]

But i need the second row, in the solution provided by you, second row is skipped

[Ray_Sha1 (Ray Sha)]

No. The query works fine.
But i need the second row…

[raja.arslankhan (Raja Muhammad Arslan khan)]

@Ray_Sha1 what is your out after runing query… I am confuse little bit about output

[Ray_Sha1 (Ray Sha)]

The input file is below

after reading the input file, the datatable is as below:

The required output is as below

Any idea?

[Gokul001 (Gokul Balaji)]

Hi @Ray_Sha1

Have a look on the XAML file

LinqFilter.xaml (9.5 KB)

Output

Regards
Gokul

[raja.arslankhan (Raja Muhammad Arslan khan)]

@Ray_Sha1 can you please show me filter activity which you are using