Filter year/Date from excel

[kuih_sedap]

I need to filter data start from 2020 in column planned start,Can i use filter data table activity in this case?

[tdhaene (tom Dhaene)]

Yes you can

[kuih_sedap]

Why i cant use contains? “Planned start” Contains “2020”.Is that wrong?

[kuih_sedap]

help please

[ImPratham45 (Prathamesh Patil)]

@kuih_sedap

rt from 2020 in column planned start,C

are you using it in filter datatable activity?

[kuih_sedap]

yes i use in filter datatable

[ImPratham45 (Prathamesh Patil)]

Then it will work…

[kuih_sedap]

yes it work but not accurate

[ImPratham45 (Prathamesh Patil)]

accurate in terms of???

[kuih_sedap]

I need a count from “phase” = deployment ,“planned start”="2020"

[kuih_sedap]

it state zero

[GBK]

you can use Datatable.Select method to query -
like below -

dt1.Select(“phase = ‘deployment’ and planned start like ‘%2020%’”)

[supermanPunch (Arpan)]

@kuih_sedap Can you try this Linq :
DT1.AsEnumerable().Where(Function(row) row(“Phase”).ToString.Trim.Tolower.Equals(“deployment”) and row(“Planned Start”).ToString.Trim.Tolower.Contains(“2020”)).CopyToDataTable

[hacky (NotHacker)]

@kuih_sedap

Please check your input excel file, if it actually has “Planned Start” to be containing “2020” and
“Phase” to be equal to be “Development”…

I never saw the above combination in your screenshots of excel file.

Check if you are dealing with the correct excel…

As i checked with Filter data table… I was able to filter my dummy data using the conditions…

Thanks and Regards,
@hacky,

[kuih_sedap]

The file is right,I’ve filtered manually and the data is right.

But it still state zero

[hacky (NotHacker)]

@kuih_sedap
Can you share your excel?

I will create a flow and share with you instantly.

[hacky (NotHacker)]

@kuih_sedap

I guess there was something wrong with the excel (atleast in my case)…

When I try to open the excel file manually, i get below error:-

Also, When I try to open the excel file using the UiPath activity(Read Range - Workbook), I get the below error:-

Kindly help me understand, what exactly is happening here, in my case.

Thanks and Regards,
@hacky

[supermanPunch (Arpan)]

@kuih_sedap Can you try this and Check
FilterDT.zip (65.1 KB) is and Check

[kuih_sedap]

How can i select multiptle items from column Phase?

[supermanPunch (Arpan)]

@kuih_sedap you’ll need to modify the Linq Query a bit, Tell me the condition