1.1 Expected effect

Check the values in the fields and group them according to the field values, display A if the field contains A and B if the field contains B. For example, "Province or City" containing "Province" is displayed as 1, as shown in the following figure.

1.2 Implementation idea

Use the Find function to determine if the value exists in the field, and the IF function to make a conditional determination.

Use Demo Data"Regional Data Analysis".

2.1 Add Self-Service dataset

Create the Self-Service dataset and select all the data, as shown below.

2.2 Add new column

New return value column "Test", if the field contains "Province", it returns a 1, thenFind("Province",Province or City) in the IF function logical value of true, for conditional judgment, contains the display for "1", otherwise display for "0", as shown below.

2.3 Effect view

As shown in the figure below.