Filter Date and Int value
![Shashi](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar2.png)
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 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:
-
Want all the values which are grater than zero.