Adding a Column Using the IF Function

Application Scenario

When you need to classify data based on certain conditions, assign corresponding values to different sorts of data, and finally create a column to store the data, using the IF function is an appropriate approach.

Implementation Method

Functions such as AND, OR, and FIND are often nested inside the IF function for use.

For example, you want to implement fuzzy search, classify data based on certain conditions, assign corresponding values to different sorts of data, and create a column to store the data.

Drag a New Calculation Column operator into the Data Transformation node. Add a field and name it Category to label values containing Women as Women Products, Men as Men Products, or otherwise, as Others.

Enter the formula IF(FIND("Women",Category description)!=0,"Women Products",IF(FIND("Men",Category description)!=0,"Men Products","Others")), as shown in the following figure.

Note:

The Category field must be displayed with a blue background to be valid.

The following table describes the formula.

The Data Preview page displays the new column, as shown in the following figure.

Drag a New Calculation Column operator into the Data Transformation node. Add a field and name it Category to label data meeting the conditions Sales_Volume>5000 and Profit>500 as Excellent, or otherwise, as Others.

Enter the formula IF(AND(Sales_Volume>5000,Profit>500),"Excellent","Others"), as shown in the following figure.

The Data Preview page displays the new column, as shown in the following figure.