Filter Data is not working

[NervousTuber (vinit mhatre)]

This is my main excel sheet data and i want to extract the data which only contains status=pending into another sheet

This is my workflow …

But its not working properly i dont know why, its showing me only headers not the data

[pravin_calvin (pravin kumar)]

Hi @NervousTuber

Please use the below Method.

Dt.select(“[Status] =‘Pending’”).CopyToDataTable

Regards

[NervousTuber (vinit mhatre)]

@pravin_calvin

Dt.select(“[Status] =‘Pending’”).CopyToDataTable

where to pass this method? inside filter data table?

[pravin_calvin (pravin kumar)]

@NervousTuber

1. Instead of Filter datatable.
   2)create a variable type of datatable
2. then assign the method to the new datatable variable
3. Write range the new filtered datatable.

Regards

[NervousTuber (vinit mhatre)]

@pravin_calvin

Dt.select(“[Status] =‘Pending’”).CopyToDataTable

[MarioHerrmann]

readDT = the Variable Name of our DT form the Read Range Activity

alternativ kannst du die Filter-Activity verwenden und im Wizard dann einstellen:

Matching Rows: “Keep”
Column 7 - Contains - “Pending”

Und bei den Spalten gehst du auf:
“Keep”
und fügst 8 Spalten (0-7) hinzu

Sollte auch gehen

[NervousTuber (vinit mhatre)]

Yeah i already did that still not working…

[ermanoj3101 (MANOJ)]

Hi @NervousTuber ,
Try this
dt.AsEnumerable().Where(function(x) x(“Status”)= ‘Pending’).ToList.CopyToDatatable

[MarioHerrmann]

…ups … okay

see upper reply after edit

have you checkt in debug mode that the dt is filled?

[NervousTuber (vinit mhatre)]

not working

[ermanoj3101 (MANOJ)]

Can you send me that excel?

Also please make sure spaces are not their in ‘Pending’ value while running any filter method.
Try to use contain instead of equal.

[MarioHerrmann]

@NervousTuber

here is a little picture gallery for you. maybe it helps

[NervousTuber (vinit mhatre)]

thanks for your help guys
issue got resolved

[MarioHerrmann]

@ermanoj3101

I have modefied your Input to
testDT.AsEnumerable().Where(function(x) x.Item(3).Equals(“Pending”)).CopyToDataTable()

alternative i tryed …x(“Status”).Equals… its working too.

[ermanoj3101 (MANOJ)]

Thanks @MarioHerrmann but i am still wondering why it worked with column number instead of column name, Is he is not selecting headers through read range so what the default headers get created

[MarioHerrmann]

@ermanoj3101
Misunderstanding. It works both only then the function call is a little different.

With heading: x(“Status”).equals(“Pending”)
With number: x.item(3).equals(“Pending”)

I think the call by name or by index depends if the number of columns is not fixed yet but the label is

What is more important the chicken or the egg … you understand what I mean

[ermanoj3101 (MANOJ)]

Got it