Filter data table wizard

Help
,
1

Hi, I am trying to filter data from the excel sheet using a Filter data table. In that, I cant able to filter the data using (<,>,<=,>=) logic operators. Is that any package needs to install to work with logic operators.
Note: The remaining operations are working well, like Contains,=, start with,etc…
Please me out

2

Hi,
Why cant you use that operators. On what type of data are you trying to use it.

3

Hi @suma123

I dont get it what is the issue to be exact .Please elaborate more to easilly address the issue.

cheers :smiley:

Happy learning :smiley:

2 Likes
4

image
image1366×768 61.7 KB

if im using “contains”.it is working for me.
image
image1366×768 61.6 KB

if i change the operator “<,>,<=.>=”,im not able to filter data

5

Can you once remove the double quotes in the value box and try.

6

yeah!but it showing error

image
image1366×768 61.5 KB

7

You are trying to compare it with time . So you are getting that error

8

if i put In_Duration = 08:30,im getting the data to my result excel sheet.
but if i use In_Duration < 08:30, im not getting any data.
How can i over come with this, please help me