How to filter a date?

Help Studio
, , , ,
1

Here is a test. I want to know the time of John when on the day I input. For example, I want output John’s time on the “2022-7-20”, which is “11:28”.
So I firstly filter the date, than filter the name. However, the result is Null.

8fa3a0b785bfc23703615589c081c0c
8fa3a0b785bfc23703615589c081c0c1280×1704 134 KB

test.zip (64.4 KB)

2

Please tell me how to solve :sob:

3

Str=DT.Asenumerable.Where(Function(r) r(“Name”).Tostring.Equals(“John”) And Also r(“Time”).To string.Contains(YourStringinputDate)).Select(Function(r1) r1(“Time”).Tostring.Split(" "c)(1)).Last()

4

The file is only a test, actually I need to filter a lot of data, and I need to use “for each row” to get everyone’s right time on everyday. So are there any solutions using “filter”?

5

DT=DT.Asenumerable.Groupby(Function(r) r(“Name”).Tostring).Select(Function(g) g.where(Function(r1) r1(“Time”).To string.Contains(YourStringinputDate)).First()).Copytodatatable

6

Can you tell me how to use this? I’m totally a beginner :sob:… If you can give me an example file, I would appreciate it！！！

7

Hi @aureolegogogo - Can you share that excel file

8

test.zip (64.4 KB)

9

@aureolegogogo - Not able to open it. please share only excel file, that would be enough

Capture

10

Hello @aureolegogogo

Do you need it in the excel itself or you can read the excel and get the values to a datatable variable?

If datatable can be used, then you can use filter datatable activity to meet your requirement?

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

11

excel.zip (7.2 KB)

12

I need to do the filter many times, and the data is complex. I think datatable can not do it. But may be it’s just because I don’t know how to use it.

13

Hi

Not able to open this file it’s invalid file.

Regards,
Dhanush

14

you can make the filtering condition of the filter datatable activity dynamic to meet this.

15

test.xlsx (9.7 KB)

16

test.xlsx (9.7 KB)
Test.xaml (14.5 KB)

1 Like
17

@aureolegogogo - Please refer to the attached workflow

Example.zip (13.3 KB)

Output

output

Note: To retrieve the time for a specific person the user should input the name along with the date. I implemented that in the code

18

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.