1. Overview编辑
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.
2. Example编辑
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.