Filter Date and Int value

Shashi
Shashi Registered Posts: 2

There is a column in my dataset Mon [ Storage type - String , Meaning - Decimal]
Im trying to add a filter on it. Which is Mon >0. It should give me all value except 0
As there are some date values in it. So its not taking date value from it. For this filter Mon>0 its taking all the values except 0, negative and Date values.

Mon
129
325
43
0
3235
-11
0
0
47
-236
-436
28-04-2022 00:21
29-04-2022 00:21
30-04-2022 00:21

Answers

  • Miguel Angel
    Miguel Angel Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 118 Dataiker

    Hi,

    If you are looking for 'give me all value except 0', then the filter 'Mon >0' is not correct. This filter out all the values below 0, as you have mentioned. Based on your requirements, you are looking for something like 'Mon !=0'

    You can do this visually in a Prepare recipe using the 'Filter rows/cells on value' processor:

    Mon.PNG

  • Shashi
    Shashi Registered Posts: 2

    Want all the values which are grater than zero.

Setup Info
    Tags
      Help me…