Filtering a row in datatable

Help
, ,
1

Hi,

I have this excel sheet which contains a first column which has either Y or N. I need to filter the rows which has Y in the first column. I used the example from uipath academy under data manipulations in practice exercise 2 and it threw errors then I finally created an expression without errors but it wont run. Please share your ideas

2

Also let me know if there is a different approach to this problem. Thanks in advance!!!

1
11204×702 64.7 KB

3

try “bookings.Select(”[Booking Filter]=‘Y’")

When there is space in column name, we put the column name in bracket

4

Hey thanks. i tried it with a different single word name ‘Flag’. Uipath kept throwing a strange error saying Boolean cannot be converted to string. I was wondering if ‘flag’ was a keyword. then changed it to ‘booking filter’

5

Try Y without the quotes.