Hide rows selectively

For the purposes of this article, we are going to use a simple and fictitious Excel file. Consider the following raw and "uncleaned" data, where the Sales Amount is always expected to be positive.

There are negative Sales Amounts in the data set and we wish to hide these records.

Step-by-step guide

1. Create a data step and upload the data.

2. Create an action step to manipulate data.

3. Select the Hide rows selectively instruction.

4. Configure the target range to select the data set.

5.  Enter the condition(s) on which a row will be hidden and click "Add". 

In the following example, rows will be hidden on the condition that the value in column C is less than '0'.

7. Click "SAVE" and run the step. 

Once this step completes successfully, the appropriate rows will have been hidden. 

Row 6 which contained a negative Sales Amount is now hidden. 

Multiple conditions

In the Hide rows selectively instruction, you can specify more than one condition to be met, in order for a row to be hidden.

1. To add more conditions, fill the condition in the template row (the first row with the blue background colour) and remember to click "Add" after entering the condition (as seen in step 5 in the previous section).

2. In the case of multiple conditions, select whether you want ALL or ANY of the conditions to be met for the rows to be hidden.

• ALL: all conditions you enter must be satisfied for the row to be hidden
• ANY: at least one condition you enter must be satisfied for the row to be hidden

For example, suppose we would like to hide Nick's sales performance in the data set.

• Two conditions are specified and we choose to meet "ALL" the conditions for the row to be hidden. 

This will provide the following output.

Useful tips and resources

• The conditions in step 5 can be generalised into different operators. For example, we can use a wide range of various operators including the below options.

• Users can choose to fix their conditional value (select "Literal") or set it to vary depending on a property elsewhere in the process (select "Data Property Link").

          

• For those who select "Data Property Link", instead of writing a literal value in the text box, you can link the value to a data property that contains a variable value 

          

• When specifying a condition, the text can be toggled using the tick-box, depending on whether case-sensitivity is desired or leading & trailing whitespace can be ignored.