You can use cleansing rules of this type to have rule-based attribute value settings carried out in the course of the transformation. Here, a certain target value is assigned to an attribute of an item, provided that certain conditions are met for a comparison attribute of the same item. Learn more
Set up the cleansing rule
In order to create a cleansing rule of the type “Conditional attribute setting”, proceed as follows:
- From the “Choose rule type” menu, select the rule type “Conditional attribute setting”.
- Click on the
button to call up the corresponding dialog box.
- Enter a name for the rule in the “Title” field
. - From the “Order” menu
, select the desired option. You can choose between:
- Before transformation: The attribute value modification also affects the supplier attributes.
- After transformation: The The attribute value modification only affects the iPIM Supply attributes.
- From the “Attribute” menu
, select the iPIM Supply attribute to which the target value is to be assigned to.

- Optional: Enter a short rule description in the “Description” field
. - Activate respectively deactivate the cleansing rule:
- To activate the rule, tick the “Activate rule” checkbox
(default setting). - To deactivate the rule, untick the “Activate rule” checkbox.
- To activate the rule, tick the “Activate rule” checkbox
- Optional: Tick the “Internal rule” checkbox
to determine that the cleansing rule is an internal rule. Internal rules can be used as subordinate rule of certain rule types. - Define a condition for the execution of attribute value setting. This determines against which compared value the attribute value of the attribute to be compared is checked:
- From the “Attribute to compare” menu
, select the attribute to compare. - From the “Operator” menu
, select an operator. Depending on the attribute to compare, you can choose between the options:
- Equal: The value of the attribute to compare equals the compared value.
- Not equal: The value of the attribute to compare does not equal the compared value.
- Empty: The attribute to compare does not have a value.
- Not empty: The attribute to compare has a value.
- Contains: The value of the attribute to compare contains the compared value.
- Does not contain: The value of the attribute to compare does not contain the compared value.
- Starts with: The value of the attribute to compare starts with the compared value.
- Does not start with: The value of the attribute to compare does not start with the compared value.
- Ends with: The value of the attribute to compare ends with the compared value.
- Does not end with: The value of the attribute to compare does not end with the compared value.
- From the “Compared type” menu
, select a compared type. You can choose between the options:
- Attribute: The value of the attribute to compare is checked against the value of another attribute.
- Constant: The value of the attribute to compare is checked against a specified constant.
- Define a compared value:
- If the “Attribute” comparison type is selected, use the “Compared value” menu
to select the attribute which the attribute to be compared is compared to. - If the compared type “Constant” is selected, enter a value which the value of the attribute to be compared is compared to.
- If the “Attribute” comparison type is selected, use the “Compared value” menu
- Optional: Configure an additional condition. To do so, click on the
button
. Following this, a new line with empty input fields appears. Configure the additional condition as described above.
- From the “Attribute to compare” menu
- Configure the instruction that is executed when the condition is met:
- Select a target type. Depending on your selection, the input fields adjust accordingly. You can choose between the options:
- Attribute: The value of another attribute is assigned to the selected attribute. Choose the other attribute from the “Target value” menu
. - Constant: A specified value is assigned to the selected attribute. Enter the value in the “Target value” field.
- Calculation: The result of a calculation is assigned to the selected attribute. Depending on your settings, attribute values and/or constants are either added up, subtracted, multiplied or divided.
- Rule: If the condition is met, a subordinate internal rule is carried out. Select the desired rule from the “Target value” menu.
- Empty: No value is assigned to the selected attribute.
- Attribute: The value of another attribute is assigned to the selected attribute. Choose the other attribute from the “Target value” menu
- Optional: Add another rule block, To do so, click on the
button
. Following this, a new block with input fields for a condition and an instruction appears. - Optional: Configure a test run and carry it out in order to check the validity of the cleansing rule. To do so, click on the

- Select a target type. Depending on your selection, the input fields adjust accordingly. You can choose between the options:
- In order to finalise the configuration of the cleansing rule rule, click on the
button
.
The dialog box closes. “The - In order cancel the configuration of the cleansing rule, click on the
button
.
If there are several rule blocks, you can change their order using the arrow buttons. The order of the rule blocks determines the sequence of their execution. Therefore, put the rule blocks in the desired or appropriate order of execution.
You can remove individual conditions or rule blocks. To do so, click on the
button in the upper right corner of the rule block respectively in the line of the condition.
Use cases
Set up a cleansing rule for conditional category assignment
This section uses an example to explain how items are assigned to an appropriate category in the primary taxonomy based on the attribute that represents a device type. In this example, items of the device type “Coffeemaker” are mapped to the “Coffee makers” category:

- Select the option “Conditional attribute setting” from the “Choose rule type” menu
. - Click on the
button
to call up the corresponding dialog box.
- Optional: In the "Title" field
in the "Title" field. - The options in the "Order" menu
unchanged. - If it isn't already selected, check the "Activate rule” checkbox
. - Using the "Attribute to compare" menu
, select the attribute that represents the device type (In this example, “Device Type DT704”). - Select the option “= (Equal)” from the “Comperator” menu
. - Select the option “Constant” from the “Comparison type” menu
.

- Enter the value “Coffeemaker” in the “Compared value” field
. - Select the option “Constant” from the “Target type” menu
. - In the "Target value" field
.
The category category for the primary taxonomy is shown. - In the category list, click on the "Coffee makers" category.
- Click on the
button
to finalise the configuration of the cleansing rule.
The dialog box closes and a success message is shown.