Filter dates

Help Studio
1

I want to filter the dates in the multiple csv file how can i do it i am stuck with this problem for more than 3 days please help.In the csv files there is coloumn called dates i want to extract the data based on the given date that is 23-05-2022

2

use read csv activity to get the datatable
use filter data table activity to filter using date

3

i have already used it but it shows the error

4

Please show the error

5

it showing no error but not showing the values when i filter the dates

6

Please share the workflow if possible

7

Download excel files.zip (3.4 KB)
this is the zip file file contains the csv file i have to extract the data corresponding to 23-05-2022 from this csv files and paste this data into another excel sheet thats my task

8

i have uploaded my csv files is that enough pls help i am new to uipath

9

Hi @alan_prakash

You can try this approach

  1. Read the csv file and store in datatable dt1

  2. Use the below assign activity to filter dates

dt2= dt1.AsEnumerable().Where(Function(row) CDate(row(“dates”).ToString).ToString(“dd-MM-yyyy”).Equals(“23-05-2022”)).CopyToDataTable

Thanks & Regards,
Nived N

10

ok let me check it

11

Filter.xaml (11.5 KB)
Hi @alan_prakash

Please check the attached file

12

ok i will check it

13

Could you please send this file in the zip i cant open it. It get stuck

14

BlankProcess.zip (8.3 KB)
check filter wf

15

ok thanks for the help i will check it

16

Please confirm if it works

17

it shows no values

Screenshot (47)
Screenshot (47)1920×1080 316 KB

and after that it shows the error

18

give a small delay before excel application scope

19

@alan_prakash Can you share your input csv file with sample data

20

Hello @alan_prakash ,

You can do as below.
1)first get all the file names. Directory.Getfiles(“fodler path”).Tostring
2)use a for each loop to the file names.(step 1 data)
3) use excel scope (give the item inside the file url)
4)Read the excel- you will get a datatable
5)use filter activity- give the column name and value to which you want to filter.