Or Group logic tables

Use the Or Group field on List (MX10.1) to define an and/or condition between attributes. This condition determines whether the attributes are grouped or treated individually. If you leave this field blank, then AND will be set as default, which connects two statements with an AND condition. You can specify any alphanumeric character in the field to define an OR condition.

You can include combinations of AND and OR conditions. AND conditions link value ranges together as one condition. For example, you might want to select user analyses for stores that are in the Central region and sell high quality products. OR conditions are used to establish multiple sets of criteria that are applied separately. For example, you might want to select user analyses for stores in the North region or the Western region.

If you have multiple conditions in a list, then use an OR in the Or Group field to separate the conditions. Selection criteria above or below an OR condition are applied separately. This table lists attribute and OR group combinations that you can combine to define conditional statements.

If the attribute on the preceding or subsequent line is	And the Or Group on the preceding or subsequent line is	Result
EQUAL	EQUAL	Not valid
EQUAL	NOT EQUAL	Or condition
NOT EQUAL	EQUAL	And condition
NOT EQUAL	NOT EQUAL	Or condition

The next table shows an example of attributes and or groups being combined to define this conditional statement: Include all transactions for Moose Wood Outfitter's stores in the Central region that fall in the high quality bracket or the low quality bracket.

Attribute	Value range	Or Group	Result	Notes
Region	Central Central	1
Quality	High High	1	And	Attributes = Not Equal Or Group = Equal
Region	Central Central	2	Or	Attributes = Not Equal Or Group = Not Equal
Quality	Low Low	2	And	Attributes = Not Equal Or Group = Equal