How to fill sale_price only for discounted products

Task

A marketplace feed should contain sale_price only when the discount is greater than 0.

Short answer

Clear the output field first, then use a rule that checks discount and inserts discount_price only for discounted products.

How to do it in Eofferix

Create sale_price from discount_price.
The output table keeps the sale price empty for a product without discount.
Use the first rule to clear the default value.
The rule checks discount and inserts the discounted price only when it is greater than zero.
Use the second rule to check discount: if it is greater than 0, insert {discount_price}.
Check products without a discount: sale_price should remain empty.

The data below is a training example and does not belong to real user files.

source data

sku	price	discount	discount_price
SKU-1001	1200	10	1080
SKU-1002	900	0	900

result

sku	price	sale_price
SKU-1001	1200	1080
SKU-1002	900