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" -> "By Setting Conditions".
How to Use?
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 BusinessTravel column value is "Non-Travel" like below screenshoot,
then you can click the condition and set it in the Filter like dialog.
Set New Values
To set a new value for each condition, click the New Value field and then Enter New Value Dialog popup. Enter value and click OK.

Assign New Values to Existing Values - Recode

Work with Categories

Last modified 6mo ago

Copy link

Contents

How to Access?

How to Use?

Set Condition and New Values

Set New Values