Assign New Values by Setting Conditions - Case When
You can assign new values to a column by setting conditions with easy-to-use dialog UI.
How to Access?
From Column Menu on Character Column, select "Replace Values" -> "With Conditions".
How to Use?
Select Target Columns
You can select a column or multiple columns for this operation. To select multiple columns, check the checkboxes for the columns you want to perform this operation.
Set Condition and New Values
To assign new value, you need to set a condition. For example, if you want to assign 100 for the case where City column value is "Tokyo" like below screenshot,
then you can click the condition and set it in the Filter like dialog.
Reorder Conditions by drag and drop
You can drag and drop a condition to reorder conditions.
Duplicate Conditions
Click the duplicate icon to duplicate a condition.
Disable / Enable Conditions
Click the Disable (or Enable) icons to toggle Condition state.
Set New Values
To set a new value for each condition, you can select either of followings:
Input Field (Text Input Field for Character column and Number Input Field for for Numeric column.)
Column
NA
Calculation
To change the type, click the button label and select the available option.
Last updated