Filter Data Table Rows Count is giving 0 after using TimeSpan.Parse

Help
1

Hi Everyone,

I am working on CSV file to to get the count of late comers punched after 08:30:00.
I have used the filter data table to get the late comers punched data by using the assing activity to convert each row of Column “1”, with TimeSpan.Parse(row.item(“1”).tostring).

But the out put rows is always 0.

Can anyone please help me on this.
Attached Workflow: Test_DailyPunched.zip (15.0 KB)

2

Likely the FilterDataTable activity doesn’t process properly the condition

Better filter using Select method

Late_DT = DailyPunchedDT.Select("[1] > '08:30:00'").CopyToDataTable

See for more:

Cheers

1 Like
3

Hi @J0ska,

Thank you very much for your reply. its worked. But why filter data table fails for the same scenario?

Regards
Vishnu

4

This is rather question to FilterDataTable activity developer :slight_smile:

@loginerror: This seems to be a defect in the activity. How to report it?

5

Hi @J0ska

The easiest would be directly from Studio:

6

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