Excel Filter for particular column

[badal_patel (Atpl)]

Dear Sir/ Ma’am,
Temp_MD.xlsx (5.9 MB)
In this file i want filter data for column AJ
i want only current year data form AJ column

[Anil_G (Anil Gorthi)]

@badal_patel

Please read the data into datatable…then use filter datatable to filter on the required dates…if you want to filter only on year then either use contains and check for /2023

Or

Use linq dt.AsEnumerable.where(function(x) Cdate(x("Document date").ToString).Year.Equals(Now.Year)).CopytoDatatable

Cheers

[Kaviyarasu_N]

Hi @badal_patel
Simply use Filter Datatable action in UiPath to filter data in datatable.

Reference Link:
https://docs.uipath.com/activities/docs/filter-data-table

Regards,
Kaviyarasu N

[ganesh_palaniappan]

Hi anil,

why are we using /2023 . what is the purpose of / here?

[Anil_G (Anil Gorthi)]

@ganesh_palaniappan

i used it to ensure it finds only from
The date…else if there is number with 2023 even that would be filtered.Hope this is clear

@badal_patel

The linq query procided needs only a assign activity with the query provided on the right and the outdt on the left

Cheers

[balupad14 (Balamurugan)]

Hi @badal_patel ,

User the Excel Filter Activity

Filter

And use the Read Range with Visible rows only.

Regards
Balamurugan.s

[badal_patel (Atpl)]

TEMP_Excel.zip (2.3 MB)
I applied but its not working
Please check this & send sollution

[Manish540 (Manish Shettigar)]

@badal_patel Please find your updated workflow attached below,
TEM_Excel_Updated.zip (2.3 MB)

Hope this may help you

[ashvani.kumar]

Hi @badal_patel

Kindly try this expression-

outDt = InputDt.AsEnumerable.Where(Function(r)

r("Year").ToString.Trim.Equals(now.ToString("yyyy"))).CopyToDataTable