Skip to main content

Boxes - Set ValueColumn If

For all the following boxes: If you work with prices, you may have to use the Make Valid Price- Box before.

1. Set Value/Column If Contains

a9fd8121420cef8321a3c7690ec9f382.png

If you want to set or assign a value/column for specific products only, you can use these boxes.

  1. First define the column where the value exists.

  2. The products all need one attribute in common that serve as the reason why you want to edit them. Insert this in the contains/compare field.

    For numerical values, you can use the signs <,> and = to indicate compare or to contain.

  3. You now can enter the value or the column to set. You can append, prepend, assign this value/column or leave it unchanged.

  4. At handle no match you can define what happens to those products that do not contain the specified value.

2. Set Value if Column Contains

85cb495d15f92150d6e64817fb0fe5a2.png

If you want to set a value if a column contains a specific word, you can use this box.

  1. First define the column where the value exists (Intermediate or Import). (In this example brand)

  2. In the free space fill in

    1st: The word you are searching for. (In this example Nike)

    2nd: The word you want to assign if Nike is found in this column. (in this example "sale:")

  3. Choose the Mode: append, prepend or assign.

  4. You can define if it should be an exact or a broad match.

  5. Choose, if only the first or all found matches should be used

4afae57f79b0b39d3f396020590b2cf6.png

3. Set Value If Value In

8784870ca1b28a494edaecc11a00c9db.png

It is basically the same as Set Value If Contains, but with this box you can set as many search terms as you want.

You can also define if it should be an exact or a broad match.

6. Add Column if Value Not Present

This box can be used to add a value from another column if it is not included already.

  1. Pick the source "Column" from where the information should be added if it is not yet included.

  2. Choose the "Mode" to decide whether the information should be added at the beginning (prepend) or ending (append) of the existing information in the column (if they are not part of the information already).

  3. The optional text field could add a static word before or after added values. This could be used in order to specify the type of information that is added as "Brand:" or "Color:"

Example:

  • Nike Air Speed

  • Nike Air Vortex Color: blue

  • Nike Air Vector

c7eb78f0056cd111ddd0c549c42067e8.png

Result:

  • Nike Air Speed Color: red

  • Nike Air Vortex Color: blue

  • Nike Air Vector Color: green

The color is added to Nike Air Speed and the Nike Air Vector but not to Vortex since it is already included there.

7. Set Value by Compare

This box sets a value by comparing columns.

ed122c1760212dcecf4d16fd995baccc.png

In this example the box searches for all the prices less than 12 (€/$/..).

For the products that cost less than 12, it writes "supersale: " before the words in the column we chose to edit.

8. Set Value by Column Compare

With this box you can set up to 2 conditions that have to fit for a value to assign.

797e467459602ba5c037df3cb3ebc4e5.png

Note:

The first and the second condition are not connected. They do not form a condition together.

1- First condition: Source Coulmn

  • Choose the source column (here price)

  • Choose a value that should be compared (here 20)

  • Choose if the value should be >/</=...(here >=)

2.-Second condition: Optional Column

  • Choose the source column (here price)

  • Choose a value that should be compared (here 5)

  • Choose if the value should be >/</=...(here <=)

3- Set Value to "ATTENTION:" prepend or set a column append/ prepend or assign

9. Set Value if Greater Than

The box Set Value if Greater Than replaces all values that are greater than the value you put in the box, by a word or number you chose for Output.

Before: Price: "13€"

4a3e16d993868535ed21905f41f762fe.png
6e3433609c63aa5afa0395bed59f2d3f.png

After: Price: "expensive"

If you work with prices, you may have to use the Make Valid Price- Box before.

10. Contains String

With this box you can replace cells if they contain a specific string.

Example:

Text before: "This are red sneakers with blue stripes."

bfe26f3afa3aa3461b0780537f943823.png

Text after: "shoes"

In this example the cell will be empty if "sneaker" is not found.

You can also put a string that should assign if the word is not found, for example "no shoes".

In this example we just search for words, but it also works with strings.