Insert if/else blank column
Last updated
Was this helpful?
Last updated
Was this helpful?
The Insert if/else blank column step enables you to insert a conditional column filter for blank values.
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.
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.
