Set a value based on an "if" condition
Use rule boxes to set the needed values in your attributes based on a condition in Productsup.
Introduction
Some of the attributes in your feed may depend on a certain condition or the values stored in other attributes. In Productsup, you can modify your values based on various conditions by using rule boxes in the following ways:
Adding a static value to your edited attribute if a chosen attribute meets a condition
Adding a dynamic value to your edited attribute if the chosen attribute meets a condition
Overwriting a value in your edited attribute if it contains a certain string
Setting a static value in the edited attribute if the current value is greater than a certain number
Adding a static or dynamic value to your edited attribute if the value of the edited attribute is empty
Adding a static value to your edited attribute if the value of the edited attribute isn't empty
Adding a dynamic value to your edited attribute if a chosen attribute isn't empty
Adding a dynamic value to your edited attribute if certain data doesn't already exist in your edited attribute
Comparing values in other attributes and assigning the needed value to the edited attribute based on the comparison results
When you add a rule box to an attribute at the intermediate stage and the rule box uses the values of another attribute, the values of the other attribute come from the import stage. If you are working at the export stage with a similar rule box, the values of the other attribute come from the intermediate stage.
Tip
If you are working with prices, you must ensure that they are valid numbers, either integers or floats, and that they don't contain any text symbols, such as commas or dots. Consider using the Make Valid Price rule box to normalize your prices. See Validate prices and convert strings to integers.
Prerequisites
This document explains how to set up the needed rule box without mentioning the steps you need to take in Dataflow or Data View to edit an attribute and open the menu where you can add a rule box.
To add a rule box in Dataflow or Data View, see Add a rule box.
Add a static value if a chosen attribute meets a condition
The following rule boxes can help you set a static value in your edited attribute based on the contents of a chosen attribute:
Set Value if Contains
Set Value if Column Contains
Set Value If Value In
Set Value If Value Not In
All these rule boxes function in a similar way. You need to choose an attribute where the rule box should search for your desired value and enter the desired value itself. If the rule box finds it, the platform assigns, prepends, or appends a desired string to the edited attribute.
See the following sections for the setup details.
Set Value if Contains
To let the platform search an attribute for a certain search term and modify the edited attribute with your desired string in case of a match, add and set up the Set Value if Contains rule box:
Search for and select the rule box Set Value if Contains.
In Source Column, select the attribute where the rule box should search for your search term.
In the compare value field, enter the search term you want the rule box to search for in the attribute chosen above. The search term can be a text string or a number.
In the contains drop-down menu, choose the needed search behavior:
Contains
If a value in the chosen attribute contains the provided search term, the rule box modifies the edited attribute.
Contains not
If a value in the chosen attribute doesn't contain the provided search term, the rule box modifies the edited attribute.
<
If a value in the chosen attribute is numeric and it is less than the provided number, the rule box modifies the edited attribute.
<=
If a value in the chosen attribute is numeric and it is less than or equals the provided number, the rule box modifies the edited attribute.
!=
If a value in the chosen attribute is numeric and it doesn't equal the provided number, the rule box modifies the edited attribute.
Note
This option also works with text values and means that the full value doesn't match the provided search term. The option is case-sensitive.
=
If a value in the chosen attribute is numeric and equals the provided number, the rule box modifies the edited attribute.
Note
This option also works with text values and means that the full value matches the provided search term. The option is case-sensitive.
>=
If a value in the chosen attribute is numeric and it is greater than or equals the provided number, the rule box modifies the edited attribute.
>
If a value in the chosen attribute is numeric and it is greater than the provided number, the rule box modifies the edited attribute.
In the assign value field, enter the desired string that the rule box should use to modify the edited attribute.
In the assign drop-down menu, choose the modifying mode that the rule box should use to change the edited attribute:
assign overwrites the current value with the desired string.
append adds the desired string at the end of the current value.
prepend adds the desired string at the beginning of the current value.
leave unchanged doesn't modify the current value at all.
In the handle no match drop-down menu, select what the rule box should do with the values that don't match the set conditions:
leave unchanged
assign
append
prepend
Note
Provide the desired no-match value in change to if you choose assign, append, or prepend in this drop-down menu.
For example, you have the following data in your feed:
title | condition |
---|---|
Slippers | new |
Blanket | used |
Socks | new |
If you add the rule box Set Value if Contains to the title
attribute, you can set it up as shown below to add the string , not used
to the titles of all products whose condition is new:
Source Column | contains | compare value | assign | assign value | handle no match | title (after) |
---|---|---|---|---|---|---|
condition | contains |
| append |
| leave unchanged |
|
| ||||||
|
Set Value if Column Contains
Add and set up the Set Value if Column Contains rule box to let the platform search an attribute for a certain search term and modify the edited attribute with your desired string in case of a match.
The difference between Set Value if Contains
and Set Value if Column Contains
is the ability of the latter to consider multiple search terms and desired strings.
Search for and select the rule box Set Value if Column Contains.
In Column, select the attribute where the rule box should search for your search term.
In the text area below, enter the search terms and add the desired strings that the rule box should use to modify the edited attribute.
The input in this field should use the format search term:desired string. See an example of applying this rule box after the setup instructions.
Tip
If you want to enter multiple search terms and desired strings, start each pair from a new line.
In Mode, choose how the rule box should modify the edited attribute:
assign overwrites the current value with the desired string.
append adds the desired string at the end of the current value and separates the string and the value with a space.
prepend adds the desired string at the beginning of the current value and separates the string and the value with a space.
In Match Mode, select how strict the match of the search term should be:
broad matches any part of the value with the search term and isn't case-sensitive.
exact matches the whole value with the search term and is case-sensitive.
In Find, select first to consider only the first match of the search term within a value or all to consider all matches within a value.
For example, you have the following data in your feed:
title | brand |
---|---|
Slippers | Gucci |
Socks | Prada |
Car | Tesla |
If you add the rule box Set Value if Column Contains to the title
attribute, you can set it up as shown below to add the strings High-Fashion
or Haute Couture
to the titles of all products whose brands are Gucci or Prada, respectively:
Column | Text area | Mode | Match Mode | Find | title (after) |
---|---|---|---|---|---|
brand |
NoteEach pair of a search term and a desired string starts from a new line. | prepend | broad | first |
|
| |||||
|
Set Value If Value In
To search another attribute for a specific search term and assign a desired string to the edited attribute if there is a match, add and set up the Set Value If Value In rule box.
Search for and select the rule box Set Value If Value In.
In Source Column, select the attribute where the rule box should search for your search term.
In Match, select how strict the match of the search term should be:
broad matches any part of the value with the search term and isn't case-sensitive.
exact matches the whole value with the search term and is case-sensitive.
In Set Value, enter the desired string that the rule box should assign to your edited attribute in case of a match.
In the text field, enter the search terms you want the rule box to search for in the attribute chosen above.
Tip
If you want to search for multiple search terms, start each search term from a new line.
For example, you have the following data in your feed:
sizes | availability |
---|---|
S, M, XXL | in stock |
L | out of stock |
XXS, M | out of stock |
If you add the rule box Set Value If Value In to the sizes
attribute, you can set it up as shown below to assign the string No sizes available
to the sizes of all products whose availability status is out of stock:
Source Column | Match | Set Value | Text area | sizes (after) |
---|---|---|---|---|
availability | broad |
|
|
|
| ||||
|
Set Value If Value Not In
To search another attribute for a specific search term and assign a desired string to the edited attribute if there is no match, add and set up the Set Value If Value Not In rule box:
Search for and select the rule box Set Value If Value Not In.
In Source Column, select the attribute where the rule box should search for your search term.
In Match, select how strict the match of the search term should be:
broad matches any part of the value with the search term and isn't case-sensitive.
exact matches the whole value with the search term and is case-sensitive.
In Then, choose how the rule box should modify the edited attribute in case of no search term match:
assign overwrites the current value with the desired string.
append adds the desired string at the end of the current value and separates the string and the value with a space.
prepend adds the desired string at the beginning of the current value and separates the string and the value with a space.
In Set Value, enter the desired string that the rule box should use to modify your edited attribute in case of no match.
In the text field, enter the search terms you want the rule box to search for in the attribute chosen above.
Tip
If you want to search for multiple search terms, start each search term from a new line.
For example, you have the following data in your feed:
sizes | availability |
---|---|
S, M, XXL | in stock |
L | out of stock |
XXS, M | out of stock |
If you add the rule box Set Value If Value Not In to the sizes
attribute, you can set it up as shown below to assign the string No sizes available
to the sizes of all products whose availability status is anything but in stock:
Source Column | Match | Then | Set Value | Text area | sizes (after) |
---|---|---|---|---|---|
availability | broad | assign |
|
|
|
| |||||
|
Add a dynamic value if a chosen attribute meets a condition
To let the platform search attribute A for a certain search term and, in case of a match, modify the edited attribute B by adding the value from attribute C, add and set up the Set Column if Contains rule box:
Note
If the values in attributes A and C change, so do the values in attribute B. That is why this attribute modification method is dynamic.
Search for and select the rule box Set Column if Contains.
In Source Column, select the attribute where the rule box should search for your search term.
In the compare value field, enter the search term you want the rule box to search for in the attribute chosen above. The search term can be a text string or a number.
In the contains not drop-down menu, choose the needed search behavior:
Contains not
If a value in the chosen attribute doesn't contain the provided search term, the rule box modifies the edited attribute.
Contains
If a value in the chosen attribute contains the provided search term, the rule box modifies the edited attribute.
<
If a value in the chosen attribute is numeric and it is less than the provided number, the rule box modifies the edited attribute.
<=
If a value in the chosen attribute is numeric and it is less than or equals the provided number, the rule box modifies the edited attribute.
!=
If a value in the chosen attribute is numeric and it doesn't equal the provided number, the rule box modifies the edited attribute.
Note
This option also works with text values and means that the full value doesn't match the provided search term. The option is case-sensitive.
=
If a value in the chosen attribute is numeric and equals the provided number, the rule box modifies the edited attribute.
Note
This option also works with text values and means that the full value matches the provided search term. The option is case-sensitive.
>=
If a value in the chosen attribute is numeric and it is greater than or equals the provided number, the rule box modifies the edited attribute.
>
If a value in the chosen attribute is numeric and it is greater than the provided number, the rule box modifies the edited attribute.
In the second Select an Option drop-down list, select the attribute storing the values that the rule box should use to modify the edited attribute.
Tip
You can choose the same attribute here as in Step 2.
In the assign drop-down menu, choose the modifying mode that the rule box should use to change the edited attribute:
assign overwrites the current value with the value of the attribute selected in Step 5.
append adds the value of the attribute selected in Step 5 at the end of the current value.
prepend adds the value of the attribute selected in Step 5 at the beginning of the current value.
leave unchanged doesn't modify the current value at all.
In the handle no match drop-down menu, select what the rule box should do with the values that don't match the set conditions:
leave unchanged
assign
append
prepend
Note
Provide the desired no-match value in change to if you choose assign, append, or prepend in this drop-down menu.
For example, you have the following data in your feed:
title | brand | price_€ |
---|---|---|
Slippers | Gucci | 510 |
Socks | Prada | 250 |
Slippers | adidas | 18 |
If you add the rule box Set Column if Contains to the title
attribute, you can set it up as shown below to prepend the value in brand
to the titles of all products whose values in price_€
are over 200
:
Source Column | compare value | contains not | Select an Option | assign | handle no match | title (after) |
---|---|---|---|---|---|---|
price_€ |
| > | brand | prepend | leave unchanged |
|
| ||||||
|
Overwrite a value if it contains a certain string
To let the platform search your edited attribute for a certain string and, in case of a match, overwrite the entire value with a new desired string, add and set up the Contains String rule box:
Search for and select the rule box Contains String.
In If value contains, enter the search term that the rule box should search for in your edited attribute.
In Set value to, enter a new desired string that should overwrite the current value in case of a search term match.
If you want to manage the non-matching cases, you can use the Otherwise set value to field to enter the string that should overwrite the current value in case of no match with the search term.
For example, you have the following data in your feed:
availability |
---|
in stock |
unavailable |
unavailable |
If you add the rule box Contains Strings to the availability
attribute, you can set it up as shown below to overwrite the value unavailable
with the string out of stock
:
If value contains | Set value to | availability (after) |
---|---|---|
|
|
|
| ||
|
Set a static value if the current value is greater than a certain number
To let the platform search your edited attribute for numbers exceeding a certain threshold and, in case of a match, overwrite the entire value with a new desired string, add and set up the Set Value if Greater Than rule box:
Search for and select the rule box Set Value if Greater Than.
In Value >, enter a threshold for the rule box to compare your current values against.
In Output, enter a new desired string that should overwrite the current value if it exceeds the threshold.
If your attribute contains not only numbers but also text strings, you can use the If column value is not a number drop-down menu to select the desired behavior:
leave unchanged doesn't modify text values at all.
treat as 0 overwrites text values with
0
.return empty string removes text and makes the values empty.
For example, you have the following data in your feed:
price_$ |
---|
5 |
55 |
555 |
If you add the rule box Set Value if Greater Than to the price_$
attribute, you can set it up as shown below to overwrite the values greater than 500
with the string too expensive
:
Value > | Output | If column value is not a number | price_$ (after) |
---|---|---|---|
|
| leave unchanged |
|
| |||
|
Add a value if the current value is empty
To let the platform add data to the empty values of your edited attribute, you can add and set up the following rule boxes:
Set Value if Empty
overwrites empty values in the edited attribute with a desired static string.Set Value if Empty (Conditional)
overwrites empty values in the edited attribute with a desired static string if another attribute meets a condition.Set Column if Empty
checks whether the edited attribute has empty values and overwrites empty values with the values of another attribute.
To set up the rule boxes Set Value if Empty and Set Column if Empty, do the following:
Search for and select the rule box Set Value if Empty or Set Column if Empty.
Enter the desired value in Static value to set or choose the needed attribute from the Select an Option drop-down menu.
To set up the rule box Set Value if Empty (Conditional), do the following:
Search for and select the rule box Set Value if Empty (Conditional).
In Source Column, select the attribute where the rule box should search for your search term.
In the compare value field, enter the search term you want the rule box to search for in the attribute chosen above. The search term can be a text string or a number.
In the contains drop-down menu, choose the needed search behavior:
Contains
If a value in the chosen attribute contains the provided search term, the rule box modifies the edited attribute.
Contains not
If a value in the chosen attribute doesn't contain the provided search term, the rule box modifies the edited attribute.
<
If a value in the chosen attribute is numeric and it is less than the provided number, the rule box modifies the edited attribute.
<=
If a value in the chosen attribute is numeric and it is less than or equals the provided number, the rule box modifies the edited attribute.
!=
If a value in the chosen attribute is numeric and it doesn't equal the provided number, the rule box modifies the edited attribute.
Note
This option also works with text values and means that the full value doesn't match the provided search term. The option is case-sensitive.
=
If a value in the chosen attribute is numeric and equals the provided number, the rule box modifies the edited attribute.
Note
This option also works with text values and means that the full value matches the provided search term. The option is case-sensitive.
>=
If a value in the chosen attribute is numeric and it is greater than or equals the provided number, the rule box modifies the edited attribute.
>
If a value in the chosen attribute is numeric and it is greater than the provided number, the rule box modifies the edited attribute.
In Set Value, enter the desired string that should overwrite your current empty values in case of a search term match.
Add a string if the current value isn't empty
To let the platform add data to non-empty values in your edited attribute, you can add and set up the following rule box:
Append/Prepend Value if not Empty
adds a static string at the beginning or end of the values in the edited attribute if they contain data.
To set up the rule box Append/Prepend Value if not Empty, do the following:
Search for and select the rule box Append/Prepend Value if not Empty.
In Mode, choose how the rule box should modify the edited attribute with the desired string:
append adds the desired string at the end of the current value without adding a space before it.
prepend adds the desired string at the beginning of the current value without adding a space after it.
Enter the desired string in Static value to set.
Add a dynamic value if a chosen attribute isn't empty
To let the platform add non-empty values of a chosen attribute into your edited attribute, you can add and set up the following rule box:
Set Column if not Empty
overwrites the values in the edited attribute with the dynamic non-empty values of another attribute. If the chosen attribute contains an empty value, the rule box doesn't overwrite the value of the edited attribute with it.
To set up the rule box Set Column if not Empty, do the following:
Search for and select the rule box Set Column if not Empty.
Choose the needed attribute from the Select an Option drop-down menu.
Add a dynamic value if certain data doesn't already exist in the attribute
To let the platform add data from a chosen attribute to the values of your edited attribute if this data doesn't yet exist in the edited attribute, add and set up the Append/Prepend Column if Value Not Present rule box:
Search for and select the rule box Append/Prepend Column if Value Not Present.
In Column, select the attribute that stores the needed data. The rule box searches this attribute and compares its values with the current values of the edited attribute. If a current value doesn't have the data stored in the chosen attribute, the rule box adds this data to the value.
In Mode, choose how the rule box should modify the edited attribute:
append adds the data from the chosen attribute at the end of the current value and separates the string and the value with a space.
prepend adds the data from the chosen attribute at the beginning of the current value and separates the string and the value with a space.
If you want to add some text before or after the data from the chosen attribute, you can use the text field to enter the desired string and select one of the options of where the rule box should add the desired string:
Text Before
Text After
For example, you have the following data in your feed:
title | brand |
---|---|
Slippers | Gucci |
Prada Socks | Prada |
Shirt | Balenciaga |
If you add the rule box Append/Prepend Column if Value Not Present to the title
attribute, you can set it up as shown below to add the values in brand
to the current titles if the data in brand
isn't already present in the titles:
Column | Mode | text | Text Before | title (after) |
---|---|---|---|---|
brand | prepend |
NoteThere is a space at the end of this string. | Text Before |
|
| ||||
|
Compare data in multiple attributes and assign a value based on the outcome
The following rule boxes can help you set a static or dynamic value in your edited attribute based on a comparison of data in one or more chosen attributes:
Set Value by Compare
Set Value by Column Compare
Set Value by Column Compare (Multicondition)
See the following sections for the differences between these rule boxes and the setup details.
Set Value by Compare
To let the platform compare the values of the chosen attribute with your desired condition and modify your edited attribute with the desired string, add and set up the Set Value by Compare rule box:
Search for and select the rule box Set Value by Compare.
In If, select the attribute where the rule box should compare values to your condition.
In Is, select the condition that the values of the chosen attribute should meet:
less than
If a value in the chosen attribute is numeric and it is less than the provided number, the rule box modifies the edited attribute.
less or equal
If a value in the chosen attribute is numeric and it is less than or equals the provided number, the rule box modifies the edited attribute.
equal to
If a value in the chosen attribute is numeric and equals the provided number, the rule box modifies the edited attribute.
Note
This option also works with text values and means that the full value matches the provided string. The condition is case-sensitive.
greater than
If a value in the chosen attribute is numeric and it is greater than the provided number, the rule box modifies the edited attribute.
greater than or equal
If a value in the chosen attribute is numeric and it is greater than or equals the provided number, the rule box modifies the edited attribute.
In value to compare, enter a number for the specified condition.
In Then, choose how the rule box should modify the edited attribute if the value in the chosen attribute meets the specified condition:
assign column to overwrites the current value with the desired string.
append adds the desired string at the end of the current value.
prepend adds the desired string at the beginning of the current value.
In output if comparison is true, enter the desired string that should modify your edited attribute if the value in the chosen attribute meets the specified condition.
For example, you have the following data in your feed:
title | price_$ |
---|---|
Slippers | 10 |
Socks | 1 |
Shirt | 55 |
If you add the rule box Set Value by Compare to the title
attribute, you can set it up as shown below to add the string Cheap
if the value in price_$
is less than 10
:
If | Is | value to compare | Then | output if comparison is true | title (after) |
---|---|---|---|---|---|
price_$ | less than |
| prepend |
NoteThere is a space at the end of this string. |
|
| |||||
|
Set Value by Column Compare
Add and set up the Set Value by Column Compare rule box to create two (2) connected conditions with two (2) chosen attributes and modify your edited attribute with the desired static or dynamic value if both conditions are satisfied:
Note
You don't have to use both conditions for the Set Value by Column Compare rule box to work. You can set up only one condition if you need one.
Search for and select the rule box Set Value by Column Compare.
In Source Column, select the attribute where the rule box should compare values to meet your first condition.
In the first contains drop-down menu, choose your first condition:
Contains
A value in the chosen attribute should contain the provided string or number.
Contains not
A value in the chosen attribute shouldn't contain the provided string or number.
<
A value in the chosen attribute should be numeric and less than the provided number.
<=
A value in the chosen attribute should be numeric and less than or equal to the provided number.
!=
A value in the chosen attribute should be numeric and shouldn't equal the provided number.
Note
This option also works with text values and means that the full value shouldn't match the provided string. The condition is case-sensitive.
=
A value in the chosen attribute should be numeric and should equal the provided number.
Note
This option also works with text values and means that the full value should match the provided string. The condition is case-sensitive.
>=
A value in the chosen attribute should be numeric and greater than or equal to the provided number.
>
A value in the chosen attribute should be numeric and greater than the provided number.
In the first compare source value field, enter a string or a number for your first condition.
In Optional Column, you can select another attribute where the rule box should compare values to meet your second condition.
In the second contains drop-down menu, you can choose your second condition.
In the second compare source value field, you can enter a string or a number for your second condition.
To specify what the rule box should do if the data in both chosen attributes meets the defined conditions, choose whether you want to assign a static value to all your products or set a dynamic value depending on the values of another attribute:
In Set Value, enter the desired string to modify your edited attribute with a static value.
In the Select an Option drop-down list, select the needed attribute to modify your edited attribute with dynamic values.
In the assign drop-down menu, choose how the rule box should modify the edited attribute if the data in both chosen attributes meets the specified conditions:
assign overwrites the current value with the desired string.
append adds the desired string at the end of the current value.
prepend adds the desired string at the beginning of the current value.
For example, you have the following data in your feed:
title | price_$ | stock |
---|---|---|
Slippers | 10 | out of stock |
Socks | 1 | in stock |
Shirt | 55 | in stock |
If you add the rule box Set Value by Column Compare to the title
attribute, you can set it up as shown below to add the string - Best Price
at the end of the value if both conditions are met:
The number in
price_$
is less than15
The value in
stock
is in stock.
Source Column | contains (1) | compare source value (1) | Optional Column | contains (2) | compare source value (2) | Set Value | assign | title (after) |
---|---|---|---|---|---|---|---|---|
price_$ | < |
| stock | = |
|
NoteThere is a space at the beginning of this string. | append |
|
| ||||||||
|
Set Value by Column Compare (Multicondition)
Add and set up the Set Value by Column Compare (Multicondition) rule box to create two (2) connected conditions with two (2) chosen attributes and modify your edited attribute with the desired static string if both conditions are satisfied:
Note
The difference between the rule boxes Set Value by Column Compare and Set Value by Column Compare (Multicondition) is that the latter lets you specify multiple combinations of values for the conditions. It also lets you add static values only.
Search for and select the rule box Set Value by Column Compare (Multicondition).
In Source Column 1, select the attribute where the rule box should compare values to meet your first condition.
In the first Match type drop-down menu, choose your first condition:
Contains
A value in the chosen attribute should contain the provided string or number.
Contains not
A value in the chosen attribute shouldn't contain the provided string or number.
<
A value in the chosen attribute should be numeric and less than the provided number.
<=
A value in the chosen attribute should be numeric and less than or equal to the provided number.
!=
A value in the chosen attribute should be numeric and shouldn't equal the provided number.
Note
This option also works with text values and means that the full value shouldn't match the provided string. The condition is case-sensitive.
=
A value in the chosen attribute should be numeric and should equal the provided number.
Note
This option also works with text values and means that the full value should match the provided string. The condition is case-sensitive.
>=
A value in the chosen attribute should be numeric and greater than or equal to the provided number.
>
A value in the chosen attribute should be numeric and greater than the provided number.
In Source Column 2, select another attribute where the rule box should compare values to meet your second condition.
In the second Match type drop-down menu, choose your second condition.
In the text field Search Values Column1:Column2, enter the strings or numbers for your conditions in the following format: desired string for condition 1:desired string for condition 2.
Tip
To enter multiple combinations of values for both conditions, start each pair from a new line.
In Set Value, enter the desired string to modify your edited attribute with a static value if the data in both chosen attributes meets the specified conditions.
In the assign drop-down menu, choose how the rule box should modify the edited attribute if the data in both chosen attributes meets the specified conditions:
assign overwrites the current value with the desired string.
append adds the desired string at the end of the current value.
prepend adds the desired string at the beginning of the current value.
For example, you have the following data in your feed:
title | price_$ | age_group |
---|---|---|
Pants | 80 | kids |
Skirt | 15 | kids |
Shirt | 55 | adults |
If you add the rule box Set Value by Column Compare (Multicondition) to the title
attribute, you can set it up as shown below to add the string - Best Price
at the end of the value if one of the conditions is met:
The number in
price_$
is less than20
for the products with the value kids inage_group
.The number in
price_$
is less than60
for the products with the value adult inage_group
.
Source Column 1 | Match Type (1) | Source Column 2 | Match Type (2) | Search Values Column1:Column2 | Set Value | assign | title (after) |
---|---|---|---|---|---|---|---|
price_$ | < | age_group | = |
NoteEach pair of values starts from a new line. |
NoteThere is a space at the beginning of this string. | append |
|
| |||||||
|