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
If you want to set or assign a value/column for specific products only, you can use these boxes.
First define the column where the value exists.
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.
You now can enter the value or the column to set. You can append, prepend, assign this value/column or leave it unchanged.
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
If you want to set a value if a column contains a specific word, you can use this box.
First define the column where the value exists (Intermediate or Import). (In this example brand)
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:")
Choose the Mode: append, prepend or assign.
You can define if it should be an exact or a broad match.
Choose, if only the first or all found matches should be used
3. Set Value If Value In
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.
Pick the source "Column" from where the information should be added if it is not yet included.
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).
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
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.
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.
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€"
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."
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.