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.
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".
Create the Self-Service dataset and select all the data, as shown below.
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.
As shown in the figure below.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy