The Insert if/else blank column step enables you to insert a conditional column filter for blank values.

Insert if/else blank column

Input/output

The data we will use for this step consists of 4 columns "First Name", "Last Name", "Gender" and "Email".



New column name "IF ELSE" will be added into the table, It will check the "Gender" column.

If the column cell is not blank the "OK" value will be added into "IF ELSE" column cell.

If the column cell is blank the "NA" value will be added into "IF ELSE" column cell.



Settings

Pick the dataset.
Type the new column to be added into the table "New column name".
Type the column name in "Column to check", it's determine the column name or index in which the condition should take place.
Choose from "Condition" dropdown the following options:
is blank
is not blank

Type in "New column value" the value if the condition match.
Type in "Fail column value" the value if the condition does not match.

Was this article helpful?
Cancel
Thank you!