Filtering Data Using Conditions

you can apply condition based filtering to extract specific information and gain deeper insights from your dataset.

To do so:

1. Under Add a step, click Reshape. A dropdown displays.

   
2. From the dropdown, click Filter. The filter step gets added.

   
3. From the Column dropdown, select a column to be used in this condition. For example, we have selected the column “sex”.

   
4. Specify a condition. The available condition values are:

   • Equal to

   • Not equal to

   • Contains

   • Not contains

5. Specify the value for the second column.

   For example, in the image below, we have added the condition to display the data where sex is equal to the male.

   
6. In case you want to use multiple conditions, click add filter and apply another condition in the same way.

7. Use AND or OR operators as required while using multiple conditions.

8. After defining the condition, click Execute Filter. The dataset gets filtered as per the condition(s) applied.