Insert if/else blank column
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.
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.
Updated on: 20/09/2022
Thank you!