Excel filter activity is not working

Help Automation Ops
,
1

Excel filter activity is not working.I’m trying to filter the values starts with 1 in excel filter activity but the values are not filtering.

2

Hi @anjani_priya

If you’re trying to filter digit values in Excel using the Filter activity, it won’t work because they are in Number format. For values in Text format, you can use the “Starts With” filter.

Hope you understand!!

3

dt_FilteredTable = YourDataTable.AsEnumerable().Where(Function(row) row.Field(Of String)(“ColumnName”).StartsWith(“1”)).CopyToDataTable()

Try using this LINQ in assign activity

Regards,

1 Like
4

Hie @anjani_priya you can try this logic to check if the value is start with 1 or not

The image shows a UiPath workflow script utilizing a 'For Each' activity to iterate through a list of integers and an 'If' activity to check if the current number starts with '1'. (Captioned by AI)
The image shows a UiPath workflow script utilizing a 'For Each' activity to iterate through a list of integers and an 'If' activity to check if the current number starts with '1'. (Captioned by AI)1335×586 36.2 KB

this will check if the number start with 1 or not

1 Like
5

It worked. I didn’t format the cells , the numbers are in string format then the ‘starts with’ worked

1 Like
6

It’s my pleasure… @anjani_priya

Happy Automation!!

1 Like
7

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