Condition Judgment Logic Description has briefly introduced four types of condition judgment logic, which are In, Not In, Contain, and Not Contain. If you are unclear about the differences between In and Contain, as well as Not In and Not Contain, read this document for a detailed explanation.
Contain: whether one set includes all elements of another set. If A contains B, all elements of B are in A, representing a relationship between a part and the whole. Example:
"This is a test text" contains "a test", but does not contain "text test", and does not contain "a text".
If Set A = {1, 2, 3, 4} and Set B = {2, 3}, A contains B.
In: whether an element is in a set.If the element A is in Set B, A is a member of B, emphasizing the relationship between an element and a set. Example:
If Set A = {1, 2, 3, 4}, the element "3" is in Set A.
The element "test text" is in the set {test text, test text 1, example}, but is not in the set {test, text}, and is not in the set {test text experiment}.
The details of the sample data are shown in the following figure.
Condition to be set: Ship City Contain Nanjing
If the condition is set as:
Ship City Contain Nanjin,Nan jing. The result is empty.
Ship City Contain Nan. The result will display data where Ship City is Nanjing and Nanchang.
Condition to be set: Ship City In Nanjing.
Ship City In Nanjing area. The result is empty.
Ship City In Nan,jing. The result is empty.
Condition to be set:
If the condition is set as: Ship City Contain Nanjing,Beijing. The returned result is empty.
If A contains B, B can only be a single text value rather than multiple ones.
The condition to be set: Ship City In Nanjing,Beijing.
If A is in B, B can include multiple text values.
The condition to be set: Ship City Contain empty value. The returned result is all data (Data with null values are included in the result, while data with empty values are not included in the result.)
The condition to be set: Ship City In empty value. The returned result: all data (including data with null values and empty values).
Not Contain: If A does not contain B, some elements of Set B are not in Set A.For example:
If Set A = {1, 2, 3, 4} and Set B = {2, 5}, A does not contain B.
"This is a test text" does not contain "test-text", "tes tex", nor "a text".
Not In: If A is not in B, element A is not in Set B.For example:
If Set A = {1, 2, 3, 4}, the element "5" is not in Set A.
The element "test text" is not in the set {test, text} nor the set {test text experiment}.
The condition to be set: Ship City Not Contain Nanjing. The returned result displays data where Ship City does not have the value Nanjing. (Data with null values in Ship City are included in the filtering result, while data with empty values are not included.)
The condition to be set:
The result returns data where Ship City does not have the values Nanjing and Beijing. (Data with null values in Ship City are included in the filtering result, while data with empty values are not included.)
The condition to be set: Ship City Not Contain Nanjing,Beijing. The returned result displays all data except data where Ship City is empty.
The condition to be set: Ship City Not Contain empty value. The returned result is empty
.
The condition to be set: Ship City Not In empty value. The returned result is empty.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy